MongoDB aggregation results in an Array

Question

I made some MongoDB aggregation like this:

db.first_collection.aggregate(
[
  { $lookup: {
        from:"second_collection",
        localField:"fisrt_id",
        foreignField:"second_id",
        as:"result"
      }
  },
  { $redact: {
        $cond: {
           if: { "$eq": [ "$result", [] ] },
           then: "$$DESCEND",
           else: "$$PRUNE"
         }
       }
  },
]
)

The output is:

{ "_id" : ObjectId("5a32249969e74c004161acc8"), "name" : "n1", "createdAt" : ISODate("2017-12-14T07:13:28.048Z"), "updatedAt" : ISODate("2017-12-14T07:13:28.048Z"), "result" : [ ] }
{ "_id" : ObjectId("5a69a60382e7d3002e6c7c74"), "name" : "n2", "createdAt" : ISODate("2018-01-25T09:40:19.098Z"), "updatedAt" : ISODate("2018-01-25T09:43:46.508Z"), "result" : [ ] }

Instead of Objects, I need an array containing only IDs. like:

["5a32249969e74c004161acc8", "5a69a60382e7d3002e6c7c74"]

Please let me know how?

the db collections are huge, but I only need to join them on id. I came across "aggregation" and tried to do some "$project" after the "$redact", but it was not successful. — Adel
– Adel, Commented Mar 6, 2018 at 16:37

Rahul Sharma · Accepted Answer · 2018-03-06 16:51:33Z

10

try this

db.getCollection('TEST').aggregate([
    {$group:{
           "_id":"",
            "id":{
                $push : "$_id"
            }
    }},
    {$project:{"id":1,"_id":0}}
])

Output

{
    "id" : [ 
        ObjectId("5a5c99d2a8cb4105acaa6b96"), 
        ObjectId("5a5c99dfa8cb4105acaa6b99")
    ]
}

edited Mar 6, 2018 at 16:51

answered Mar 6, 2018 at 16:41

Rahul Sharma

10.1k1 gold badge20 silver badges41 bronze badges

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

Collectives™ on Stack Overflow

MongoDB aggregation results in an Array

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