Filters
This document covers information about filtering result sets when querying collection endpoints
TL;DR
@TODO ABOUT FILTERS
Beside the paramterization like number of results per page or the attribute the results are ordered by or the offset to start described here, the wunderbon REST API
supports more complex filtering. Only Resultsets
returned by a collection can be filtered. The Filters
are applied on the whole collection before it is returned from the server. Only the filtered Resultsets
are returned.
Operators & Parameters
You can make use of different more or less complex Filters
which can be applied using the Operators
shown below. This legend gives an brief overview of the Operators
supported for using the Filters
provided.
Filter Support
Be aware that not every endpoint supports
Filters
. Only endpoints returning a collectionResultset
supportingFilters
. See the overview tables of endpoints for more details.
Operator | Description | Example |
---|---|---|
__eq | Find column equal with value | ?name__eq=smith |
__not | Not same with given value | ?active__not=true |
__ne | Negation, the opposite of equal | ?name__ne=smith |
__lt | Lower than | ?age__lt=10 |
__gt | Greater than | ?age__gt=15 |
__lte | Lower than and equal | ?age__lte=25 |
__gte | Greater than and equal | ?age__gte=20 |
__like | Like with case sensitive | ?name__like=smith |
__ilike | Like with case insensitive (Postgres) | ?name__ilike=smith |
__notLike | Opposite of like with case sensitive | ?name__notLike=smith |
__notILike | Opposite of like with case insensitive (Postgres) | ?name__notILike=smith |
__in | Find value which listed on given list | ?city__in=düsseldorf,munich,frankfurt |
__notIn | Find value which not listed in given list | ?city__notIn=köln,leipzig,wuppertal |
__contains | Find value that contains in given list (Postgres) | ?name__contains=smith |
__between | Find value which between 2 given values | ?date__between=2015-06-18,2017-05-31 |
__notBetween | Find value which is not between 2 given values | ?date__notBetween=2015-06-18,2017-05-31 |
Updated over 2 years ago
Continue with our guided tour. Now, we would like to tell you more about which HTTP Verbs
are supported by the wunderbon API ...