How to query nested objects

Question

MongoDB I have one document, I need to get one object, if locale.en then it will return that info if locale.fr' then it will return that info

{
   "locale": {
        "en": {
          "dashboard": {
            "DASHBOARD_TITLE": "Some title"
          }
        },
        "fr": {
          "dashboard": {
            "DASHBOARD_TITLE": "Some title french"
          }
        },
        "pr": {
          "dashboard": {
            "DASHBOARD_TITLE": "Some title portugues"
          }
        }
      }
    }

How to query this specific object?

db.collectionName.find({locale.en})

do you have a variable called locale with a property called en - oh, wait, that's not valid syntax at all anyway - that's not how you pass anything in javascript — Bravo
– Bravo, Commented Feb 18, 2022 at 5:20

Rijo · Accepted Answer · 2022-02-23 14:22:17Z

1

You can achieve this using aggregation

Assuming your object has key locale like this

{
"_id": <Some Object Id>,
"locale": {
  "en": {
    "dashboard": {
      "DASHBOARD_TITLE": "Some title"
    }
  },
  "fr": {
    "dashboard": {
      "DASHBOARD_TITLE": "Some title french"
    }
  },
  "pr": {
    "dashboard": {
      "DASHBOARD_TITLE": "Some title portugues"
    }
  }
 }
}

Then aggregation would be

[{
"$project": {
  "locale": {
    "$arrayToObject": {
      "$filter": {
        "input": {
          "$objectToArray": "$locale"
        },
        "as": "el",
        "cond": {
          $eq: [
            "$$el.k",
            "en"
          ]
        }
      }
    }
  }
 }
}]

Just pass your locale in $eq array as second value, I've passed en you can use variable here to build query

Playground: https://mongoplayground.net/p/7ZHIUx_j1GY

Answer on this question explains the pipeline in detail MongoDB projection on specific nested properties

Playground: https://mongoplayground.net/p/wuv4axIMzCc

Dynamic query : https://mongoplayground.net/p/5ouZif-MIry

edited Feb 23, 2022 at 14:22

Rijo

3,0436 gold badges41 silver badges68 bronze badges

answered Feb 18, 2022 at 5:27

Hussam

1,72612 silver badges20 bronze badges

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

2 Comments

Rijo Over a year ago

how to bind the dynamic properties. for eg: "locale": { this property needs to change from locale.$parm1: {

Hussam Over a year ago

@Rijo I am not sure what you are trying to do. Also the dynamic query link you added in answer is not a right mongo query, consider removing it from answer

Collectives™ on Stack Overflow

How to query nested objects

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related