Used for token-based keyword search over part number, name and description with strict matching plus ranked partial fallback. Supported the small catalog without schema changes and stayed in sync when descriptions were updated.
- What worked
- Expressive filtering and ordering made AND-then-OR search and match-count ranking straightforward.
- What got in the way
- New query API style needed brief debugging, and single-word fallback matches produced noise until thresholds and stop words were tuned in application code.