CODEWITHSUNDEEP
node.jsmongodbmongoose
fivepointseven
fivepointseven

Reputation: 1051

Mongoose optional search query parameters?

I have a following situation. I need to build a mongoose query, based on certain arguments if present.

I.e. if object like this is passed

{
    player: "nickname",
    action: "capture"
}

the following search is performed:

Entry.find({
    player: obj.player,
    action: obj.action
}).
    exec(function(err, res){
        console.log(res);
    });

If I need to exclude "action" from search if action is not in the object, what should I do? Using ternary operator like action: (obj.action) ? obj.action:null doesn't work, as would search entries in DB where action is null.

Upvotes: 17

Views: 18763

Answers (3)

Mr5o1
Mr5o1

Reputation: 1828

With ES6, you can do this with a splat & ternary like this:

Entry.find({
  player: obj.player,
  ...obj.action ? { action: obj.action } : {}
})
.exec(function(err, res){
    console.log(res);
});

Upvotes: 10

JohnnyHK
JohnnyHK

Reputation: 311865

Build up your query object programmatically:

var query = {
    player: 'player'
};

if (obj.action) {
    query.action = obj.action;
}

Entry.find(query).exec(function(err, res){
    console.log(res);
});

Upvotes: 44

fivepointseven
fivepointseven

Reputation: 1051

In case someone encounters same question, here's how I solved it:

var query = {
    player: 'player'
};

Entry.find({
    player: query.player,
    action: (query.action) ? query.action:/.*/
}).
    exec(function(err, res){
        console.log(res);
    });

Upvotes: 5

Related Questions