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, Feb 03 '17 at 19:17
Possible duplicate of [Find documents whose array field contains at least n elements of a given array](http://stackoverflow.com/questions/37725694/find-documents-whose-array-field-contains-at-least-n-elements-of-a-given-array) — styvane, Feb 03 '17 at 19:58

score -1 · Answer 1 · answered Feb 03 '17 at 19:42

-1

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

answered Feb 03 '17 at 19:42

Diego Maia

1 Answers1