home / fishbowl_archive / dataexport

dataexport: 25

This data as json

id dataQuery dateCreated dateLastModified description lastChangedUserId name
25 Select part.num, part.description, 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.description like "%label%" and bom.num not like "0%" and bom.num not like "ab%" 2026-02-25 16:32:00.638000 2026-02-25 16:34:24.039000   46 Label BOMs
Powered by Datasette · Queries took 1.372ms