Basically, I have a collection where documents have nested objects, and I want to query documents which have certain fields, and certain subdocuments, by using an array of fields.
Hi @Project_PlaDat,
Welcome to MongoDB community!
I believe you could use the $all or $any operators with $elemMatch:
https://docs.mongodb.com/manual/reference/operator/query/all/#use-all-with-elemmatch
Please let me know if that helps
Thanks
Pavel