MongoDB: Using an array to find value in array atribute

Question

I have the following code

//My search array
var charArray=['a','b','c']

{
    name: 'object1',
    myChar: ['a','v','x']
}

{
    name: 'object2',
    myChar: ['f','h','y']
}

I want to get the object which contains a value in its attribute.

I hope to get the first object using this:

db.getCollection('myObjects').find({
    'myChar':{
        $in:charArray
    }
})

The response is null. In fact I tried using $elemMatch without success

db.getCollection('myObjects').find({
    'myChar':{
        $elemMatch: {$in: charArray}
    }
})

did you run the query again ? It should give you the expected response. — s7vr
– s7vr, Commented Feb 3, 2017 at 19:17
Possible duplicate of Find documents whose array field contains at least n elements of a given array — Sede
– Sede, Commented Feb 3, 2017 at 19:58

Diego Maia · Accepted Answer · 2017-02-03 19:42:25Z

-1

I thing you have a typo because I replicate your situation in mongodb instance and your $elemMatch solution works just fine.

answered Feb 3, 2017 at 19:42

Diego Maia

403 bronze badges

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

1 Answer 1