Skip to main content

Filters

Fyso supports simple filters in query_records and field-based filters in the REST API.

Filters in MCP (query_records)​

The filter parameter accepts an expression with the format:

field operator value

Operators​

OperatorDescriptionExample
=Equals (case-insensitive)estado = activo
!=Not equalestado != inactivo
>Greater than (numeric)precio > 1000
<Less than (numeric)stock < 10
>=Greater than or equaltotal >= 500
<=Less than or equaldescuento <= 20
containsContains text (case-insensitive, accent-sensitive)nombre contains juan

Examples​

query_records({ entityName: "productos", filter: "precio > 100" })
query_records({ entityName: "clientes", filter: "nombre contains perez" })
query_records({ entityName: "facturas", filter: "estado = pagada" })

contains behavior​

contains is implemented as a PostgreSQL ILIKE query against the stored field value.

Case sensitivity: contains cafe matches Cafe, CAFE, and cafe. Case is ignored.

Accent sensitivity: ILIKE does not normalize Unicode. contains cafe does not match Café. To match records with accents, include the accent in the search value: nombre contains Café.

Partial matches: the value is matched anywhere in the field. contains an matches Juan, Ana, and Mariana.

Notes​

  • String values do not need quotes, but they are supported: nombre = "Juan Perez"
  • Numeric comparisons (>, <, >=, <=) convert values to numbers
  • contains and startsWith filters run as database queries (server-side). All other operators also run server-side when using the filters= expression syntax

Filters in REST API​

The REST API supports field-based filters using query parameters:

GET /api/entities/{entityName}/records?filter.estado=activo&filter.ciudad=buenos+aires

It also supports full-text search:

GET /api/entities/{entityName}/records?search=juan+perez

Semantic search uses vectors to find records by meaning similarity, not by exact text match.

query_records({
  entityName: "productos",
  semantic: "algo para sentarse en la oficina",
  minSimilarity: 0.6,
  limit: 10
})

When using semantic, the simple filter can be combined to post-filter the results.