How to find document from collection based on nested values

Question

How to get document by nested value such as "brand" or "storageId" from "trigger.value".

{
    "_id":  "60aee243fff5082ca6fba951",
    "status": "Good",
    "trigger": {
        "value": "{"brand":"A","storageId":"2","emplId":"3"}"
    }
}

Are you looking to get only selective values returned from the DB? — Karan Gaur
– Karan Gaur, Commented Jun 1, 2021 at 13:34
I would like to get elements which have values "brand" = A and "storageId" = 2 — Artem Manko
– Artem Manko, Commented Jun 1, 2021 at 13:39

Karan Gaur · Accepted Answer · 2021-06-01 13:54:52Z

3

This should do the trick

db.collection.find({"trigger.value.brand":"A"})

You could add more columns by CSV. This practice is known as dot notations. More on this here

answered Jun 1, 2021 at 13:54

Karan Gaur

8598 silver badges20 bronze badges

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

Collectives™ on Stack Overflow

How to find document from collection based on nested values

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related