dataexport: 21
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 21 | Select part.num, part.description, bomitem.stage From bomitem Inner Join part on bomitem.partid = part.id where bomitem.stage = false and part.num not like "labor%" and part.num not like "ab%" and part.num not like "d%" and part.num not like "0%" and part.num not like "g%" and part.num not like "t%" and part.num not like "serv%" and part.num not like "b%" and part.num not like "f%" and part.num not like "rg%" and part.num not like "nre%" group by num | 2026-02-25 13:51:43.910000 | 2026-02-25 14:22:36.747000 | 46 | Purchased Part |