search

fishbaugher / WAweb-Issues

A repository to track issues with WAweb usage. This includes problems, work arounds, shortcuts, and workflow suggestions
0 stars 0 forks source link

Measure Type - H&S changes to Other #46

Open BrianaParrBaker opened 6 months ago

BrianaParrBaker commented 6 months ago

In Defined Measures library, itemized cost is listed as H&S. When it appears in the work order, Measure Type is Other.

Library: Library

Work Order: WO

fishbaugher commented 6 months ago

Confirmed: I think what is going on is that in v8, a REFERENCE to the User Defined Measure is stored with the run results, then, when work order are created, ALL of the information available from the User Defined Measure (including comments) is COPIED into the work order measure. This is done with SQL code that runs behind the Create Work Order button in the MS Access UI.

We need to implement the same logic in the WAweb version since the Itemized Cost schema does not support all the information available to the User Defined Measures in the Setup Library.

eckmanwe commented 6 months ago

Please provide one example work order for investigation.

BrianaParrBaker commented 6 months ago

Minnesota Valley Action Council Inc.- work order 763-498-1281_WO_001 Both "Install Bath Fan" and "CO Monitor is Needed" switched from H&S to Other

In library: CO library Fan library

In work order: CO WO Fan WO