Part Lookup

Custom SQL query returning 500 rows (hide)

SELECT
  num         AS "Part #",
  description AS "Description",
  details     AS "Details",
  activeFlag  AS "Active",
  stdCost     AS "Std Cost",
  id          AS "Internal ID"
FROM part
WHERE num LIKE '%' || :search_term || '%'
   OR description LIKE '%' || :search_term || '%'
ORDER BY num
LIMIT 500

Query parameters

search_term

Edit SQL