Filtering | Estactics Developers

Search and count endpoints take a filters list. Each filter names a field, a mode and a value:

{
  "fields": ["id", "fullName"],
  "filters": [
    { "city": { "mode": "EQEM", "value": ["Limassol"] } }
  ],
  "limit": 25
}

Combining filters

Fields inside one item must all match (AND). Separate items are alternatives (OR).

{
  "filters": [
    { "city": { "mode": "EQEM", "value": ["Limassol"] }, "doNotContact": { "mode": "EQ", "value": false } },
    { "city": { "mode": "EQEM", "value": ["Paphos"] } }
  ]
}

This finds clients in Limassol who can be contacted, plus everyone in Paphos.

Modes

Mode	Works on	Meaning
`EQ`	All	Text: contains any of the values, ignoring case. Other types: equal to.
`EX`	All	The opposite of `EQ`. Text filters also match empty fields.
`EQEM`	Text	Exactly equal to one of the values.
`EXEM`	Text	Not exactly equal to any of the values.
`RG`	Numbers, dates	Between two values: `[from, to]`.
`NRG`	Date and time	Not between two values.
`GT`, `GTE`	Numbers, dates	Greater than, or greater than or equal to.
`LT`, `LTE`	Numbers, dates	Less than, or less than or equal to.
`EM`	All	The field is empty. Send `null` as the value.
`NEM`	All	The field is not empty. Send `null` as the value.