Aggregate the arrays in MongoDB

Question

I have a database structured like this:

            {
                "teams" : [
                    {
                        "best_players" : [
                            {
                                "contact" : {
                                    "name" : "SomeName1"
                                }, 
                                "characteristic" : {
                                    "skills" : "good"
                                 }
                                }
                        ], 
                        "teamname" : "SomeTeam1"
                    }, 
                    {
                    "best_players" : [
                        {
                            "contact" : {
                                "name" : "SomeName2"
                            }, 
                            "characteristic" : {
                                "skills" : "bad"
                             }
                            }
                    ], 
                    "teamname" : "SomeTeam2"
                } 
                    ]
              }

I need to rename arrays and fields, and see the information in a different form. What i'm expecting with aggregation-framework:

{
"team_players" : [
{
"player_name" : "SomeName1",
"player_skills" : "good" ,
"team_name" : "SomeTeam1"
},
{
"player_name" : "SomeName2",
"player_skills" : "bad" ,
"team_name" : "SomeTeam2"
}
]
}

What is the right way to query my result?

what should happen when best_players array has more than one player ? — s7vr
– s7vr, Commented Aug 1, 2018 at 15:48
It always has one field, but in the structure it is specified as an array — Vladimir Loct
– Vladimir Loct, Commented Aug 1, 2018 at 15:53

s7vr · Accepted Answer · 2018-08-01 15:57:44Z

1

You can use $map within $project to format documents.

Something like

db.colname.aggregate(
{"$project":{
  "team_players":{
    "$map":{
      "input":"$teams",
      "in":{
        "$let":{
          "vars":{"best_player":{"$arrayElemAt":["$$this.best_players",0]}},
          "in":{
            "player_name":"$$best_player.contact.name",
            "player_skills":"$$best_player.characteristic.skills",
            "team_name":"$$this.teamname"
          }
        }
      }
    }
  }
}})

answered Aug 1, 2018 at 15:57

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

4 Comments

Vladimir Loct Over a year ago

I have 1 more quastion, what should i do when best_player array has more than one player?)

s7vr Over a year ago

what do you want to do ? do you want to get all the players under best players array ?

Vladimir Loct Over a year ago

I mean that in one element in teams array can be more than one player

s7vr Over a year ago

Sorry. I don't follow you. do you mind creating a new question with sample documents, code that you have tried and expected response ?

Collectives™ on Stack Overflow

Aggregate the arrays in MongoDB

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related