Filtering

If you want to filter the data directly on the server, which boosts the performance of your application, then this documentation gives you more information about this.

If you missing some and filter functions, don't hesitate to contact the product owner. Otherwise, you can try to implement a (temporary) clientside solution.

Basic overview of a filter object

{
  "column": "YOUR_COLUMN",
  "operator": "OPERATOR",
  "value": "VALUE"
}

The filter object always is built with three properties. The first property column defines the column, which should be filtered. The second property operator does filter the column and value according to the value provided there. You can find a full list of all filters below. The last property contains the value, which should be searched for in the data.

Multiple filters

Of course, you can combine multiple filters in one request, therefore you put all the filter objects in an array. Please note that these filters are all combined with the AND (&&) operator. So the data has to pass all filters in order to get displayed.

Operators

Operator	Description
==	Equal, the data in the row has to be exactly the same as the provided value.
==i	Equal, the data in the row has to be exactly the same as the provided value. (case-insenitive)
<	Lower than, works only on numbers. Just show all numbers below the value.
>	Greater than, works only on numbers. Just show all the numbers above the value.
starts	Starts with, show all entries, that starts with the provided value.
ends	Ends with, show all entries, that ends with the provided value.
starts_i	Starts with, show all entries, that starts with the provided value. (case-insensitive)
ends_i	Ends with, show all entries, that starts with the provided value. (case-insensitive)
contains	Contains, show all entries, which have at least the provided value inside of it.
contains_i	Contains, show all entries, which have at least the provided value inside of it. (case-insensitive)

The operators above can be used in the filter object.