dataexport: 8
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 8 | Select bomitem.description, part.num, part.description, bomitem.quantity, bom.num, bom.activeFlag, bom.description From bomitem Inner Join part on bomitem.partid = part.id Inner Join bom on bomitem.bomid = bom.id where part.num like '10112' And bom.activeflag = 1; | 2025-03-26 12:44:30.350000 | 2025-10-29 18:46:39.889000 | Enter the part number on line 12 as 'XXX' as the part you wish to see a list of boms where it is used and then export. Only returns active BOMs | 46 | Where used |