Waterline ORM (sails.js) "where or" in query

user_2659879 0
Viewed 20745

I would like to know how to add "OR" condition in waterline query. Should look like:

User.find().where({

    score: { '>': req.params.score},
    status: 'user'
    OR
    status: 'admin'


}).exec(function(err, data){
    ...
});

So we have 2 conditions:

1) Score > specific number

And 2) status = user

OR

1) Status = admin.

waterline sails.js orm javascript
2 Answers
let userResult=await User.find().where({
score: { '>': parseInt(req.params.score)},
or: [{ status: 'user'},{status: 'admin'}]})
user_57787560
Related