Sales Orders by Customer

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
JOIN customer ON so.customerId = customer.id
WHERE customer.name LIKE '%' || :customer_name || '%'
ORDER BY so.dateIssued DESC

Query parameters

customer_name

Edit SQL