Aggregate match documents using nested documents

Question

I have a document structure as so:

{
   "name": "Bob",
   "configurations": [
      {
         "version": 0,
         "isValid": true,
         "isPublished": false
      },
      {
         "version": 1,
         "isValid": false,
         "isPublished": true
      }
   ]
}

I wish to find all such document where there exists a configuration where both isValid is true and isPublished is true. For such a query, the example I gave above should not be returned since the none of the configurations have both of the flags set as true.

I first tried something like:

coll.aggregate([
   {
      $match: {
         "configurations.isValid": true,
         "configurations.isPublished": true
      }
   }
])

This isn't what I want because this simply checks if there exists a configuration with isValid set to true and if there also exists another configuration with isPublished set to true. I tried fixing this via:

coll.aggregate([
   {
      $match: {
         "permissions": {
            "isValid": true,
            "isPublished": true
         }
      }
   }
])

but this returns zero results. Any ideas?

EDIT:

Figured it out:

coll.aggregate([
   {$match: { configurations: { $elemMatch: { $and: [ {isValid: true}, {isPublished: true}  ] } } }}  
])

Answer 1

Playground

$elemMatch will help you to find arrays with condition matches.

db.collection.find({
  configurations: {
    "$elemMatch": {
      "isValid": true,
      "isPublished": true
    }
  }
})

For aggregation, Example, Simply use the above in $match