GraphQL

Filters

Filtering data in a request

You can apply filters to any field depending on type.

Chose any field from Table Schema

Syntax:

field__filter

Example:

Loading...



Available filters:

  • exact - Exact match (this is default one when you use seqno: 1 e.g.)
  • contains - Case-sensitive containment test
  • in - In a given list
  • gt - Greater than
  • gte - Greater than or equal to
  • lt - Less than
  • lte - Less than or equal to
  • range - In a given range [val_from, val_to], both included
  • isnull - Takes either True or False, which correspond to SQL queries of IS NULL and IS NOT NULL, respectively
  • friendly - Filter by user-friendly form of address. Accepts bounceable, non-bounceable and raw form (workchain:address)
  • friendly_in - Filter on a list of addresses in user-friendly form. Accepts bounceable, non-bounceable and raw form (workchain:address)

AND / OR / NOT

1. and__: This filter is used to apply a logical AND to multiple conditions. (default one when you use several keys: {workchain: -1, seqno: 1} = workchain = 1 AND seqno = 1

Loading...



2. or__: This filter is used to apply a logical OR to multiple conditions.

Loading...



3. not__: This filter is used to negate a condition.

Loading...



4. Nested Filters (max depth: 3)

Loading...