dataexport: 33
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 33 | SELECT wo.num AS wo_number, wo.dateFinished, p.num AS glass_part_num, p.description AS glass_description, u.name AS uom, wi.qtyUsed, fp.num AS finished_part_num, fp.description AS finished_part_description, mi.qtyFulfilled AS qty_produced, fu.name AS finished_uom FROM woitem wi JOIN part p ON p.id = wi.partId JOIN wo ON wo.id = wi.woId JOIN uom u ON u.id = p.uomId JOIN womoview wmv ON wmv.WOID = wo.id JOIN moitem mi ON mi.moId = wmv.MOID AND mi.typeId = 10 JOIN part fp ON fp.id = mi.partId JOIN uom fu ON fu.id = mi.uomId WHERE ( p.num LIKE 'CLAD%' OR p.num LIKE 'LF5%' OR p.num LIKE 'F2%' ) AND wo.dateFinished >= '2026-01-01' AND wo.dateFinished <= '2026-04-30' AND wo.dateFinished IS NOT NULL ORDER BY p.num, wo.dateFinished | 2026-05-06 11:37:23.752000 | 2026-05-06 11:37:23.752000 | Change dates to get length of finished goods as well | 51 | Glass_Usage_With_FG_Length |