Find Purchase Order by Number

Custom SQL query returning 3,454 rows (hide)

SELECT
  po.num               AS "PO #",
  po.dateIssued        AS "Date Issued",
  vendor.name          AS "Vendor",
  po.vendorContact     AS "Vendor Contact",
  po.statusId          AS "Status",
  po.totalIncludesTax  AS "Total (incl. Tax)",
  po.buyer             AS "Buyer",
  po.note              AS "Notes"
FROM po
LEFT JOIN vendor ON po.vendorId = vendor.id
WHERE po.num LIKE '%' || :po_number || '%'
ORDER BY po.dateIssued DESC

Query parameters

po_number

Edit SQL