Search Purchase Orders

Search filters for purchase orders.

The query field accepts a Postgres tsquery expression evaluated against the search_vector column (which covers both supplier_name and item_description, tokenized with the simple config — no stemming, no stop-word filtering, automatic word-boundary matching).

Operators: & (AND), | (OR), ! (NOT), parens for grouping

Tokens with multiple words must be combined explicitly — there's no implicit AND. Hyphenated words tokenize both as the full string and the parts (CDW-G becomes cdw-g, cdw, g — any of those will match).

Examples: "lightspeed" Match the word lightspeed in either field.

"lightspeed & systems"
    Both words must appear (any order, either field).

"lightspeed | securly | goguardian"
    Any of the three.

"(lightspeed | securly) & !pos & !demo"
    Either competitor, but exclude POS systems and demo POs.

"((cdw & cisco) | (amazon & networking)) & 2026"
    Reseller-aware nested query.

Malformed queries return HTTP 400 with the Postgres syntax error.

At least one of institution_ids or query must be supplied — the endpoint rejects requests with both empty to prevent unbounded scans.