Create object in aggregation

Question

I have this result after group by UserId with Aggregation Framework. I want create a single Document with "merge" array foo and ability

My Aggregation

{
    "result" : [ 
        {
            "_id" : {
                "userId" : ObjectId("53bab268ceee750615240269")
            },
            "foo" : [ 
                "0.109", 
                "0.105", 
                "0.50", 
                "0.1", 
                "foo"
            ],
            "ability" : [ 
                "Power", 
                "Energy", 
                "ReactiveEnergy", 
                "Stamina", 
                "bar"
            ]
        }
    ],
    "ok" : 1
}

I like to have

{
    "result" : [ 
        {
            "_id" : {
                "userId" : ObjectId("53bab268ceee750615240269")
            },
            "fooFinal" : [ 
                {"0.109",power} 
                {"0.105",Energy }
                {"0.50",ReactiveEnergy }
                {"0.1",Stamina }
                {"foo",bar}
            ],
        }
    ],
    "ok" : 1
}

I want to use like similar $each, but i can't use it inside aggregate

That would not be a valid structure for the result. Do you actually mean just getting those values under different keys or as arrays of the "pairs"? — Neil Lunn
– Neil Lunn, Commented Jul 10, 2014 at 10:30
Additionally, it would really help to have some idea of the structure of the original documents you are getting this result from. All you have posted is what your aggregation result currently is and what you want to get ( with an invalid structure ). It helps to know where you are coming "from" as a source document and also what you are currently doing, as in your current aggregation operation. — Neil Lunn
– Neil Lunn, Commented Jul 10, 2014 at 10:55
As at MongoDB 2.6, there is no array indexing operator in the Aggregation Framework so I'm not sure how you would combine the two arrays. It would definitely be helpful to see what document format you started with as there may be an easier way to make the transformation. I would also suggest upvoting/watching SERVER-4589 in the MongoDB Jira issue tracker, which is the feature request for an array indexing operator. — Stennie
– Stennie, Commented Jul 21, 2014 at 5:00

Barno · Accepted Answer · 2014-07-10 10:47:01Z

4

Try to do This in your $group

 $group:{
    _id:{'userId':'$userId'},
    'fooFinal' : {$push:{
        foo:'$foo',
        ability:'$ability'}
    }
}

answered Jul 10, 2014 at 10:47

Barno

3,3415 gold badges31 silver badges60 bronze badges

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

Collectives™ on Stack Overflow

Create object in 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