mongo $in query isn't working with sails.js find method

Question

var arr=[18,5,6,....]; Beneficiary.find({Ward: { $in: arr } }).done(function(err,ben) { if(err) console.log(err); else { console.log(ben); } });

I want to fetch those records from Beneficiary collection where Ward are from arr list. This code gives no error but returns blank array []. Although data is there in the database.

Answer 1

Use $in keyword only if you are playing with Collection.native(...). Since you are not, use:

Beneficiary.find({ Ward: arr }); As you can see in docs.

Answer 2

You can not directly use array in IN operator you can use like this :

Beneficiary.find({Ward: { $in: [arr[0],arr[1]] } })