[ad_1]
A sample collection
[
{
"_id":"id1",
"usersArray":[
{
"name":"user1Name",
"type":1
},
{
"name":"user2Name",
"type":1
},
{
"name":"user3Name",
"type":2
},
]
},
{
"_id":"id2",
"usersArray":[
{
"name":"user4Name",
"type":1
},
{
"name":"user5Name",
"type":3
},
{
"name":"user6Name",
"type":2
},
]
},
{
"_id":"id3",
"usersArray":[
{
"name":"user7Name",
"type":1
},
{
"name":"user8Name",
"type":1
},
{
"name":"user9Name",
"type":2
},
]
},
]
What I need is a filter that will return the documents with _id id1 and id3 since they have more than 1 objects in usersArray which have key-value pairs "type": 2
. It would be great if you could resolve this with just the filter.
[ad_2]