Find Sales Order by Number

Custom SQL query returning 3,211 rows (hide)

SELECT
  so.num            AS "Order #",
  so.dateIssued     AS "Date Issued",
  customer.name     AS "Customer",
  so.customerPO     AS "Customer PO",
  so.statusId       AS "Status",
  so.totalPrice     AS "Total",
  so.salesman       AS "Salesman",
  so.note           AS "Notes"
FROM so
LEFT JOIN customer ON so.customerId = customer.id
WHERE so.num LIKE '%' || :order_number || '%'
ORDER BY so.dateIssued DESC

Query parameters

order_number

Edit SQL