Filtering with OR

[matdrapeau]

How can I filter using OR on multiple attributes?

[lyschoening]

That is not supported. You can write a custom filter if you would like this functionality.

[matdrapeau]

@lyschoening How would you represent the api syntax in order to support OR filters?

[matdrapeau]

@lyschoening What about a list to represent OR expressions?

searching for author AND title:
/books?where={"author": {"$contains": "John"}, "title": {"$contains": "Python"}}

searching for author OR title:
/books?where=[{"author": {"$contains": "John"}}, {"title": {"$contains": "Python"}}]

searching for author OR (title AND description) expressions:
/books?where=[{"author": {"$contains": "John"}}, {"title": {"$contains": "Python"}, "description": {"$contains": "Python"}}]

searching for (author AND title) OR (title AND description) expressions:
/books?where=[{"author": {"$contains": "John"}, "title": {"$contains": "Python"}}, {"title": {"$contains": "Python"}, "description": {"$contains": "Python"}}]