MongoDB search results for values only matching array items

Question

Folks,

I am able to search MongoDB Collection for any value in an array:

var searchArray = ['foo','bar'];

with the following query:

var query = {
    widgets: {
        '$in': searchArray
    }
};

The result will be Objects that have widgets that match either foo or bar.

What should the MongoDB query look like to search for widgets that are foo and bar and nothing else. In other words, only widgets that have foo and bar in them will be returned. If there is a [foo,bar,baz`] it will be skipped. If there is only a ['foo'], it will be skipped as well.

Thanks!

UPDATE: This seems to work:

var query = {
    widgets: {
        '$all': searchArray
    }
};

Anything wrong with using $all ?

JohnnyHK · Accepted Answer · 2014-07-09 18:01:42Z

1

Build your query object as a straight-up match:

var searchArray = ['foo','bar'];
var query = {
    widgets: searchArray
};

answered Jul 9, 2014 at 18:01

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Cmag Over a year ago

why not use $all ? docs.mongodb.org/manual/reference/operator/query/all

JohnnyHK Over a year ago

@Cmag Because $all would also match widgets: ['foo', 'bar', 'baz'].

Collectives™ on Stack Overflow

MongoDB search results for values only matching array items

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related