Mongodb find query array starts with element

Question

I have collection where document like: ``` { "_id" : 1, "path" : [ 3, 1 ], "name" : "A" } { "_id" : 2, "path" : [ 3, 1, 1 ], "name" : "B" } { "_id" : 3, "path" : [ 3, 1, 1, 1 ], "name" : "C" } { "_id" : 4, "path" : [ 3, 1, 2 ], "name" : "D" } { "_id" : 5, "path" : [ 3, 1, 2, 1 ], "name" : "E" } { "_id" : 6, "path" : [ 3, 1, 3 ], "name" : "F" } { "_id" : 7, "path" : [ 3, 2 ], "name" : "G" } { "_id" : 8, "path" : [ 3, 2,1 ], "name" : "H" } ``` Now I’m trying to query which all path starts with 3,1: ``` db.exp3.find({"path": {"$elemMatch": {"0": 3}}}); ``` not working . Any hints?

Accepted Answer

You can query it as follows :

```
db.myObject.find({"path.0" : 3, "path.1" : 1})
```

Mongodb find query array starts with element

Solution

Problem