fetch record(s) based on array element value in mongoDB

Question

I have a collection named test something like below {"_id": ObjectId("ciwhciwiwh686ddd") "playerName": "Jon Doe" "Player Team": "Team1" "points": [ {"date": "01-01-2018", "score": 145}, {"date": "01-01-2019", "score": 200} ]

Went thru mongoDB official documents and tried following methods

db.test.find({"Player Team": "Team1"}, {"points": {"date":"01-01-2018"}})

I also tried

db.test.find({"Player Team": "Team1"}, {"points.date":"01-01-2018"})

I'm getting Unsupported projection option:

you are getting "Unsupported projection option" error bcs your query is wrong. — niranjan_harpale, Sep 01 '19 at 06:36
try ------- db.test.find({"Player Team": "Team1", "points": {"date":"01-01-2018"}}) — niranjan_harpale, Sep 01 '19 at 06:36
or ---- db.test.find({"Player Team": "Team1" , "points.date":"01-01-2018"}) — niranjan_harpale, Sep 01 '19 at 06:36

score 0 · Answer 1 · answered Aug 31 '19 at 23:56

0

The $elemMatch operator matches documents that contain an array field with at least one element that matches all the specified query criteria.

db.test.find({"Player Team": "Team1"}, {"points": {$elemMatch {"date":"01-01-2018"}}})

answered Aug 31 '19 at 23:56

flowgician

63
1
1
7

fetch record(s) based on array element value in mongoDB

1 Answers1