Search for an object with a specific value in an array in MongoDB

Question

I have an array of objects in my document which resides in a collection in MongoDB. And, it looks like the following

"tracking": [{
    "track_id" : "abcd",
    "timestamp" : 1604581360,
    "status" : "approved",
    "category" : "containers",
    "time_of_activity" : "23:11",
    "date_of_activity" : "03-Oct-20"
}, {...}, ...]

I want to search for an object on this array where the track_id of the object is abcd

I am having a hard time writing a Mongo Aggregation for the same. Can anyone please show me a way, to how this can be achieved using a Mongo Aggregation query?

afarag · Accepted Answer · 2021-02-24 12:21:55Z

1

You can query embedded documents inside an array using find as below:

db.collection.find({"tracking.track_id": "abcd"})

Playground

answered Feb 24, 2021 at 12:21

afarag

513 bronze badges

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

Collectives™ on Stack Overflow

Search for an object with a specific value in an array in MongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related