Project objects to array results mongodb

Question

I have a data set that looks like the one below

[{
 _id: ObjectID(),
 data: {
    key1: value,
    key2: value
 }
},
{ 
_id: ObjectId(),
data: {
  key1: value,
  key2: value
}
}]

I want to convert the same into

[
 [_id,key1,key2], [_id,key1,key2]
]

I have tried the aggregation framework but couldn't come up with any way of doing this. I want to avoid looping over the objects if possible but don't know if it would be possible to do so.

Alex Blex · Accepted Answer · 2017-03-01 14:59:38Z

4

Nothing to explain really. Pretty basic $project and $group:

db.collection.aggregate([
    {$project : {data : ["$_id", "$data.key1", "$data.key2"]}},
    {$group : {_id : null, result : {$push : "$data"}}}
]);

answered Mar 1, 2017 at 14:59

Alex Blex

37.2k7 gold badges53 silver badges86 bronze badges

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

Collectives™ on Stack Overflow

Project objects to array results mongodb

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related