[ mongodb ] find array of hash

TL;DR;

use $elemMatch

long answer

collectionA

{"x" :
{ "y":
{"z":
{"m":
[
{"key": "prXXXXX",
"count": 1},
{"key": "pr12345",
"count": 2}
]
}
}
}
}

Query

db.collectionA.find({ "x.y.z.m": {$elemMatch: { "key":"prXXXXX", "count": {$gt:1} } } })

 

ref : http://www.w3resource.com/mongodb/mongodb-elemmatch-operators.php

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s