dataexport: 26
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 26 | SELECT pi.description AS "Part Description", pi.partnum AS "Part Number", v.name AS "Vendor", p.datecreated AS "Date Entered", p.id AS "PO_ID", p.buyer AS "Buyer" FROM po p JOIN poitem pi ON pi.poid = p.id JOIN vendor v ON p.vendorid = v.id WHERE datecreated > '2026-04-01' ORDER BY p.datecreated; | 2026-04-14 08:56:23.852000 | 2026-04-14 08:59:07.166000 | Change the date on line 5 to retrieve POs entered after that date. | 51 | Searching for POs after a specific date |