dataexport: 31
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 31 | 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 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 WHERE ( p.num LIKE 'CLAD%' OR p.num LIKE 'LF5%' OR p.num LIKE 'F2%' ) AND wo.dateFinished >= '2025-01-01' AND wo.dateFinished <= '2026-03-31' AND wo.dateFinished IS NOT NULL ORDER BY p.num, wo.dateFinished | 2026-05-05 12:35:48.918000 | 2026-05-05 12:35:48.918000 | Glass usage between two dates | 51 | Glass_Usage_Date |