dataexport: 17
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 17 | SELECT p.num AS PartNum, t.id AS TagId, t.num AS TagNum, t.qty, t.qtyCommitted, (t.qty - IFNULL(t.qtyCommitted,0)) AS AvailableQty FROM part p JOIN tag t ON t.partId = p.id WHERE p.num = '16204-17' AND t.locationId = ( SELECT l.id FROM location l JOIN locationgroup lg ON lg.id = l.locationGroupId WHERE CONCAT(lg.name,'-',l.name) = 'Main-ISI' OR l.name = 'Main-ISI' LIMIT 1 ) ORDER BY t.dateCreated, t.num; | 2026-02-18 09:28:47.340000 | 2026-02-18 09:28:47.340000 | returns the location.id plus a “DisplayName” in the same LG-LOC format you see in Fishbowl | 17 | Real Loc ID |