Please log in to access this content. You will be redirected to the login page shortly.
LoginGeneral Tech Bugs & Fixes 3 years ago
Posted on 16 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.
No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.
Please log in to access this content. You will be redirected to the login page shortly.
Login
manpreet![Tuteehub forum best answer]()
Best Answer
3 years ago
Retrieve only the queried element in an object array in MongoDB collection
Suppose you have the following documents in my collection:
{ "_id":ObjectId("562e7c594c12942f08fe4192"), "shapes":[ { "shape":"square", "color":"blue" }, { "shape":"circle", "color":"red" } ] }, { "_id":ObjectId("562e7c594c12942f08fe4193"), "shapes":[ { "shape":"square", "color":"black" }, { "shape":"circle", "color":"green" } ] }Do query:
db.test.find({"shapes.color": "red"}, {"shapes.color": 1})Or
db.test.find({shapes: {"$elemMatch": {color: "red"}}}, {"shapes.color": 1})Returns matched document (Document 1), but always with ALL array items in shapes:
{ "shapes": [ {"shape": "square", "color": "blue"}, {"shape": "circle", "color": "red"} ] }However, I'd like to get the document (Document 1) only with the array that contains color=red:
{ "shapes": [ {"shape": "circle", "color": "red"} ] }How can I do this?