dataexport: 30
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 30 | SELECT p.num AS part_num, p.description, u.name AS uom, SUM(wi.qtyUsed) AS total_qty_used, COUNT(DISTINCT wo.id) AS wo_count 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 >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH) AND wo.dateFinished IS NOT NULL GROUP BY p.id, p.num, p.description, u.name ORDER BY total_qty_used DESC | 2026-05-05 11:25:54.966000 | 2026-05-05 11:25:54.966000 | Chnage interval on line 16 | 51 | GLASS Usage |