Mongo DB - Filter specific nested object array

Question

I have the following Mongo structure

{
    "brand": "test",
    "keyword": "test",
    "user": "test",
    "link": "AAA",
    "text": "test",
    "insert_utc_ts": "2021-11-04 23:18:34.970",
    "update_utc_ts": "2021-11-04 23:45:55.561",
    "media": [{
        "src": "Test2",
        "media_ai_text": "Test",
        "media_type": "PHOTO_TEST",
        "insert_utc_ts": "2021-11-04 23:23:30.315",
        "update_utc_ts": "2021-11-04 23:23:30.315"
    }, {
        "src": "Test",
        "media_ai_text": "Test",
        "media_type": "PHOTO_TEST",
        "insert_utc_ts": "2021-11-04 23:23:45.331",
        "update_utc_ts": "2021-11-04 23:23:45.331"
    }]
}

I need to find the Media update_utc_ts where media.src = Test2 and link = AAA

I've tried to use this filter

{ link: "AAA", media.src: "Test2"}

But it's not working at all. Any help is appreciated Thx

Did you try { link: "AAA", "media.src": "Test2"}?

Wernfried Domscheit
– Wernfried Domscheit

2021-11-05 10:11:55 +00:00
Commented Nov 5, 2021 at 10:11 — Wernfried Domscheit
– Wernfried Domscheit, Commented Nov 5, 2021 at 10:11
yes but not working

user3925023
– user3925023

2021-11-07 21:25:20 +00:00
Commented Nov 7, 2021 at 21:25 — user3925023
– user3925023, Commented Nov 7, 2021 at 21:25

J.F. · Accepted Answer · 2021-11-05 00:09:02Z

1

You can use $unwind to deconstruct the array and then $match by your desired value. And optional stage $project to return only the value you want:

db.collection.aggregate([
  {
    "$unwind": "$media"
  },
  {
    "$match": {
      "link": "AAA",
      "media.src": "Test2"
    }
  },
  {
    "$project": {
      "_id": 0,
      "media.update_utc_ts": 1
    }
  }
])

Example here

Note that I'm assuming you want to retrieve media.update_utc_ts and that's why your filter query doesn't work.

answered Nov 5, 2021 at 0:09

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3925023 Over a year ago

Thx, my problem is that I'm using a RobotFramework library, and I'm not able to use all mongo funtion/syntax. I was hoping to have a single "find" query including media.src and the link. it is possible?

J.F. Over a year ago

Maybe $elemMatch into projection stage can helps you example but it only returns the first coincidence.

Collectives™ on Stack Overflow

Mongo DB - Filter specific nested object array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related