Mongodb array of object data conversion

Question

This is my single document of a collection. I want to convert this format data to

{ 
    "_id" : ObjectId("5e311e8bb94999f1be0d5ead"), 
    "dealer_code" : "123", 
    "mappinginfo" : [
        {
            "territory" : "MORADABAD", 
            "area" : "UPH", 
            "zone" : "N"
        }
    ], 
    "active" : NumberInt(1), 
}

like this data

{ 
    "_id" : ObjectId("5e311e8bb94999f1be0d5ead"), 
    "dealer_code" : "123", 
    "territory" : "MORADABAD", 
    "area" : "UPH", 
    "zone" : "N"
    "active" : NumberInt(1), 
}

Nikhil B · Accepted Answer · 2020-01-29 10:02:41Z

3

Here is the Query.

db.collection.aggregate([
  {
    $unwind: "$mappinginfo"
  },
  {
    $project: {
      _id: 1,
      active: 1,
      dealer_code: 1,
      territory: "$mappinginfo.territory",
      area: "$mappinginfo.area",
      zone: "$mappinginfo.zone",

    }
  },

])

answered Jan 29, 2020 at 10:02

Nikhil B

936 bronze badges

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

Comments

Anushka Ahir · Accepted Answer · 2020-01-29 09:42:09Z

2

db.collection.aggregate([
    { $unwind: "$mappinginfo" },
    {
        $project:
        {
            _id: 1,
            dealer_code: 1,
            active: 1,
            territory: "$mappinginfo.territory",
            area: "$mappinginfo.area",
            zone: "$mappinginfo.zone"
        }
    },
    { $out: "existing_collection_name" }
])

answered Jan 29, 2020 at 9:42

Anushka Ahir

1467 bronze badges

Comments

Himanshu Singh · Accepted Answer · 2020-01-29 09:55:36Z

Make use of aggregation pipeline.

Solution -

db.test.aggregate([
  { $unwind: "$mappinginfo" },
  { $project: {
    dealer_code: 1,
    territory: "$mappinginfo.territory",
    area: "$mappinginfo.area",
    zone: "$mappinginfo.zone",
    active: 1
  }}
]);

Explanation

Aggregation pipeline as the name is, works on data in pipeline. A pipeline has an input, an operator and an output. For the example above -

First stage is an unwind stage which will be fed with an entire collection. The unwind operator will iterate on individual documents and for each document it will create as many copies as are elements in mappinginfo field. For your case it will only create just one copy. After the unwind stage the resulting document would look like this -

[{ 
    "_id" : ObjectId("5e311e8bb94999f1be0d5ead"), 
    "dealer_code" : "123",
    "mappinginfo": {
        "territory" : "MORADABAD", 
        "area" : "UPH", 
        "zone" : "N"
    }
    "active" : NumberInt(1), 
}]

Notice that the mappinginfo is no more a list.

Next stage is a projection stage. $project operator will simply take the above list of documents as input and for each document either it will simply project the field as it is or will change the value of the field based on what is available in the current document. { "active": 1 } implies projecting the value as it is. { "zone": "$mappinginfo.zone" } implies projecting the value of zone inside mappinginfo field under the name zone at the root level.

More info on both operators - - $unwind - $project

Collectives™ on Stack Overflow

Mongodb array of object data conversion

3 Answers 3

Comments

Comments

Solution -

Explanation

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Solution -

Explanation

Comments

Your Answer

Sign up or log in

Post as a guest

Related