Get Array containing objects to normal object which have value as key in MongoDb result

Question

I have this in

[
  {
    "date": "2022-12-03T12:16:52.403Z",
    "configs": [
      {
        "name": "Shubham",
        "values": [
          {
            "text": "172cm",
            "type": "Height",
          },
          {
            "text": "80kg",
            "type": "Weight",
          },
          {
            "text": "male",
            "type": "Gender",
          },
        ],
      }
    ]
  },
  {....},{....}
]

Want to convert config into objects like this

[
  {
    "date": "2022-12-03T12:16:52.403Z",
    "configs": {
       "name": "Shubham",
       "Height": "172cm",
       "Weight": "80kg",
       "Gender": "male",
    }
  },
 {...},{...},
]

I know how to do in Javascript array map method but need to understand how to do in mongoDb query ($project).

you want to change the format after you query ? if so you can this with an array map — cmgchess
– cmgchess, Commented Dec 19, 2022 at 8:06
Hey @cmgchess, i know how to do in JS array method, but wanted to learn how to do same thing in mongo query — Shubham Ambastha
– Shubham Ambastha, Commented Dec 19, 2022 at 8:09

cmgchess · Accepted Answer · 2022-12-19 08:55:43Z

Here is a possible approach

First $unwind the configs since it contains only 1 element
In the $project stage use $arrayToObject to convert the [{k:'key1',v:'value1'},{k:'key2',v:'value2'}] to {key1:'value1',key2:'value2'}.
The $map stage is used to convert the field names in values array to the above format.
$concatArrays is used to concat the name field and value before converting array to object so that it becomes [{k:'name',v:'Shubham'},{k:'Height',v:'172cm'}...]

Playground Link

db.collection.aggregate([
  {
    $unwind: "$configs"
  },
  {
    $project: {
      date: 1,
      configs: {
        $arrayToObject: {
          $concatArrays: [
            {
              $map: {
                input: "$configs.values",
                as: "el",
                in: {
                  k: "$$el.type",
                  v: "$$el.text"
                }
              }
            },
            [
              {
                k: "name",
                v: "$configs.name"
              }
            ]
          ]
        },
        
      },
      
    },
    
  },
  
])

Abhi · Accepted Answer · 2022-12-19 08:09:39Z

0

Did you try this?

arr=[];
yourOutPutJson.forEach(function(b){var obj={};obj.name=b.configs[0].name;b.configs[0].values.forEach(function(c){obj[c.type]=c.text});arr.push(obj)});

answered Dec 19, 2022 at 8:09

Abhi

651 silver badge10 bronze badges

2 Comments

Shubham Ambastha Over a year ago

I know how to do in JS array method, but wanted to learn how to do same thing in mongo query

Abhi Over a year ago

Please remove the javascript tag from the question :)

Collectives™ on Stack Overflow

Get Array containing objects to normal object which have value as key in MongoDb result

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related