Return matched documents from the array

Question

I am currently trying to query a array in mongodb, I want to look for all the fields that have the id: "ZhU76Ta" in them, but the array to search is barryed in a other doc, so my query looks something like this: {"punishdata.Entrys.0.id": "ZhU76Ta"} but this only query the first doc in the array, I tryed something like this {"punishdata.Entrys.*.id": "ZhU76Ta" } but this also does not work, dose anybody know how to do this?

Document structure:
{
"_id" : ObjectId("5b212e540a975a231c85419c"),
"name" : "Starmixcraft",
"punishdata" : {
    "Entrys" : [ 
        {
            "id" : "ZhU76Ta",
            "end" : NumberLong(-2),
            "start" : NumberLong(1528901227837),
            "time" : NumberLong(-2)
        }
    ]
}
}

post your sample collection please – Ashh Jun 13 '18 at 16:15 — Ashh, Jun 13 '18 at 16:15

score 1 · Answer 1 · edited Jun 13 '18 at 16:39

1

Try this code:

db.collectionName.find({"punishdata.Entrys.id": "ZhU76Ta" })

edited Jun 13 '18 at 16:39

felipsmartins

13,269
4
48
56

answered Jun 13 '18 at 16:21

Serdar

478
3
11

That returns only the 0 entry,i want to get all entrys in the array thet matsch the quarry – Lost2 Jun 13 '18 at 16:25
do you have more values with the same id ZhU76Ta ? – Serdar Jun 13 '18 at 16:38
@NetherGames-de the current answer is correct. I'm sure you are making something wrong... – felipsmartins Jun 13 '18 at 16:39
@Serdar yes there are more values in the data thet have the id ZhU76Ta, and i want to get all of them – Lost2 Jun 13 '18 at 16:41
@NetherGames-de then try this: db.collectionName.find({"punishdata.Entrys.id": {$all:["ZhU76Ta"] }}) – Serdar Jun 13 '18 at 16:48

Ashh · Accepted Answer · 2018-06-13T17:07:04.673

You need to use $filter aggregation here which simply eliminates the unmatched documents from the array

db.collection.aggregate([
  {
    "$project": {
      "name": 1,
      "punishdata.Entrys": {
        "$filter": {
          "input": "$punishdata.Entrys",
          "as": "entry",
          "cond": {
            "$eq": [
              "$$entry.id",
              "ZhU76Ta"
            ]
          }
        }
      }
    }
  }
])

Return matched documents from the array

2 Answers2