How to make $lookup in aggregate return one object not an array

Question

when i call $lookup it return array but my requirment in only one object. is there any way where i'll get only one object. i have to put $lookup value in $group.

 Message.aggregate(

            {$match:{$or:[{"sender":userId},{"receiver":userId}]}},          
            { $lookup: {from: 'users', localField: 'senderId', foreignField: '_id', as: 'from'} },

            {$sort:{messageTimeStamp:-1}},
            {
                $group:{"_id":
                {
                  "name":
                      }
                     $cond:[
                         {
                             $eq:["$receiver",userId]
                         },
                         {$concat:["$receiver"," and ","$sender"]},
                         {$concat:["$sender"," and ","$receiver"]}
                     ]
                  }
                },"message":{$first:"$message"},
                   "time":{$first:"$messageTimeStamp"},
                   "name":{$first:{
                     $cond:[
                         {
                              $eq:['$receiver',userId]
                        },
                         "$from"
                     ]
                  }},
                }
            },

Yechezkel Deren · Accepted Answer · 2017-05-10 10:11:08Z

4

The $unwind should help you.

Deconstructs an array field from the input documents to output a document for each element.

$unwind (aggregation)

answered May 10, 2017 at 10:11

Yechezkel Deren

3662 silver badges6 bronze badges

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

2 Comments

pank sharma Over a year ago

with $unwind kind of parse object like $user1.name

Yechezkel Deren Over a year ago

$from.name. Take a look on the "as" parameter at the $lookup

Collectives™ on Stack Overflow

How to make $lookup in aggregate return one object not an array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related