MongoDB Convert sigle object to array of object based on key:value

Question

Is there a way by using mongodb queries, convert a sigle object field to an array of object but key:value based?

Before

"fields" : {
    "field1" : 1,
    "field2" : true, 
    "field3" : false, 
    "field4" : "any string value"
}

After

"fields" : [
    {
        "name" : "field1",
        "value": 1
    }, 
    {
        "name" : "field2", 
        "value" : true
    }, 
    {
        "name" : "field3",
        "value" : false
    }, 
    {
        "name" : "field4",
        "value" : "any string value" 
    }
]

J.F. · Accepted Answer · 2021-02-24 18:54:20Z

1

You can use $objectToArray in an aggregation pipeline:

db.collection.aggregate([
  {
    "$set": {
      "fields": {
        "$objectToArray": "$fields"
      }
    }
  }
])

Example here

answered Feb 24, 2021 at 18:54

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Collectives™ on Stack Overflow

MongoDB Convert sigle object to array of object based on key:value

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related