Monday, 22 May 2017

Using multiple where(or AND) which have nested or condition?

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