MongoDB - Project array subfield with aggregation

Question

Having this basic document:

{
  "_id": "userID",
  "name": "User Name",
  "profiles": [
    {
      "level": 1,
      "bar": {
        "_id": "bar1ID",
        "name": "Bar Name"
      }
    },
    {
      "level": 1,
      "bar": {
        "_id": "bar2ID",
        "name": "Bar 2 Name"
      }
    }
  ]
}

I need to remove some fields, and reassign the bar field so that it only contains the _id:

{
  "_id": "userID",
  "profiles": [
    {
      "level": 1,
      "bar": "bar1ID"
    },
    {
      "level": 1,
      "bar": "bar2ID"
    }
  ]
}

Matching with the UserID, and using the mongo aggregation framework

May help stackoverflow.com/questions/3974985/…

G. Ghez
– G. Ghez

2016-01-25 00:20:18 +00:00
Commented Jan 25, 2016 at 0:20 — G. Ghez
– G. Ghez, Commented Jan 25, 2016 at 0:20

Sede · Accepted Answer · 2016-01-25 00:22:03Z

6

Using the .aggregate() method.

The only stage in the pipeline is the $project stage where you use the $map operator.

db.collection.aggregate([
    { "$project": { 
        "profiles": { 
            "$map": { 
                "input": "$profiles", 
                "as": "profile", 
                "in": { 
                    "level": "$$profile.level",
                    "bar": "$$profile.bar._id" 
                } 
            } 
        } 
    } }
])

Which returns:

{
        "_id" : "userID",
        "profiles" : [
                {
                        "level" : 1,
                        "bar" : "bar1ID"
                },
                {
                        "level" : 1,
                        "bar" : "bar2ID"
                }
        ]
}

answered Jan 25, 2016 at 0:22

Sede

61.5k20 gold badges158 silver badges162 bronze badges

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

Collectives™ on Stack Overflow

MongoDB - Project array subfield with aggregation

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related