How to search in an array of a document?

Question

MongoDB

Hello everyone, I would be grateful for help with building a query
there is a document

{ "_id" : 1, "name" : "dave123", "status" : "active", favorites: [ "chocolate", "cake", "butter", "apples" ],  ingredients: [ "chocolate", "cake", "butter", "ice cream" ] }
{ "_id" : 2, "name" : "li", "status" : "notActive" , favorites: [ "apples", "pudding", "pie" ] ,  ingredients: [ "chocolate", "cake", "ice cream", "apples" ] }
{ "_id" : 3, "name" : "ahn", "status" : "active", favorites: [ "pears", "pecans", "chocolate", "cherries" ],  ingredients: [ "chocolate", "cake", "butter", "apples" ]  }
{ "_id" : 4, "name" : "ty", "status" : "notActive", favorites: [ "chocolate", "ice cream" ] ,  ingredients: [ "chocolate", "cake", "butter", "apples" ] }

How to filter documents in monge and get only those with status = active, where favorites has chocolate, and ingredients has ["cake", "butter"] array. I would be very grateful for help

Answer 1

see filters $eq, $in, $all