How can one query in mongodb using Waterline ORM in Sailjs, with multiple AND condition each of them having nested OR conditions.
An Example MySQL query would be:
SELECT * FROM Users WHERE (score IS NULL OR activity IS NULL) AND (invited IS NULL OR invited_by IS NULL)
Using multiple .where() doesn't seems to be working, also using all condition in OR prop destroy the logic.
Any solutions around?
via Abdullah
No comments:
Post a Comment