Review filters guide #1902
Description
This guide was written about a year ago and is starting to show its age. We should review it completely and possibly rewrite a few sections.
Filter expressions and operators
One major pain point is the list of filter operators, which no longer comfortably accommodates the growing number of operators (started with 3, now 6, will probably be further expanded soon). Additionally, the complexity of these operators has grown significantly and fitting everything (explanation, edge cases, comprehensive examples) in a single list item has become awkward.
Content to add
NOT and EXISTS
EXISTS can be negated both as attribute NOT EXISTS and NOT attribute EXISTS.
- Slack discussion on interaction between
NOTandEXISTS: https://meilisearch.slack.com/archives/C02DGTH89NE/p1664207880764789 (private link) - PR discussion on
NOTandEXISTS: https://github.com/meilisearch/documentation/pull/1869/files#r974129044
IN and OR
At the moment, IN works a bit like syntactic sugar for multiple OR statements. The implementation is actually different, however, and devs do not offer any assurances the behaviour of both operators will always match.
- PR discussion on the relationship between
INandOR: https://github.com/meilisearch/documentation/pull/1869/files#r974130580