home / fishbowl_archive / dataexport

dataexport: 10

This data as json

id dataQuery dateCreated dateLastModified description lastChangedUserId name
10 SELECT partnum, unitcost, MAX(datelastfulfillment) AS last_fulfillment_date FROM POitem GROUP BY partnum Order by partnum; 2025-04-04 17:28:54.806000 2025-04-04 17:44:45.716000 Shows the last purchase price of a component 46 Last Purchase Price
Powered by Datasette · Queries took 2.189ms