How to unwind array of object fields into array of strings in same field in mongoDB

Question

I have the following document structure:

{
    "user_id": "102",
    "roles": [{
        "name": "superuser"
    }, {
        "name": "admin"
    }, {
        "name": "account_admin"
    }]
}

And I need to unwind into the following result:

{
    "user_id": "102290863723817866607",
    "roles": [
        0: "superuser",
        1: "gsuite_admin",
        2: "account_admin"
    ]
}

I can't quite figure out how to stage the aggregation pipeline to get this result

Ayoub · Accepted Answer · 2020-11-23 00:31:47Z

3

You can use a $projectcompined with a $map to select the name from your role`s object:

db.collection.aggregate([
  {
    "$project": {
      "roles": {
        "$map": {
          "input": "$roles",
          "as": "role",
          "in": "$$role.name"
        }
      }
    }
  }
])

answered Nov 23, 2020 at 0:31

Ayoub

1,43514 silver badges24 bronze badges

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

Collectives™ on Stack Overflow

How to unwind array of object fields into array of strings in same field in mongoDB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related