Mongodb get documents matching specific field in an array

Question

I have a nested array. How can I use mongo aggregation query to get back documents, only if nested array elements has certain field and value. For example, consider this:

[
  {
    _id: 1,
    timezone: "America/New_York",
    message: "Step 1: Started",
    details: [
      {
        name: "A",
        date: "2017-02-08T12:10:40.787",
        location: "BLR11"
      },
      {
        name: "B",
        date: "2017-09-09T12:10:40.787",
        location: "BLR12"
      }
    ]
  },
  {
    _id: 2,
    message: " Step 1: Ended ",
    details: [
      {
        name: "E",
        date: "2017-05-08",
        location: "BLR31"
      }
    ]
  },
  {
    _id: 3,
    date: "2017-02-09",
    timezone: "Europe/London",
    message: "Step 2: Started",
    details: [
      {
        name: "E",
        date: "2017-05-08",
        location: "BLR11"
      }
    ]
  },
  {
    _id: 4,
    date: "2017-02-09T03:35:02.055",
    timezone: "+0530",
    message: "Step 2: In Progress"
  }
]

I want documents, which has location: "BLR11" in any of the array elements.

So with the above example, it should return back just documents with _id:1 and _id:3.

How can I do this with aggregation?

Does this answer your question? Find document with array that contains a specific value — Yadhukrishna
– Yadhukrishna, Commented Jun 25, 2020 at 18:52

mickl · Accepted Answer · 2020-06-25 18:39:36Z

1

You can use the dot notation to query an array's property:

db.collection.find({"details.location": "BLR11"})

Mongo Playground

answered Jun 25, 2020 at 18:39

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

3 Comments

Arun Nalpet Over a year ago

Wow! Thanks for the instant response! This is exactly the result I am looking for, but how can i achieve the same using aggregation pipeline?

mickl Over a year ago

@ArunNalpet same query, just use $match: mongoplayground.net/p/kr52sy1690t

Arun Nalpet Over a year ago

@micki Thanks that helped! I can add more operations to pipeline along with this! :)

Collectives™ on Stack Overflow

Mongodb get documents matching specific field in an array

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related