Mongoose returns empty array while mongodb terminal returns the required results [duplicate]

Question

A query gave me the required result in MongoDB while it's returning an empty array in mongoose

db.users.aggregate([

{$match:{_id:ObjectId("5d5a8b83352b262670a4d47b")}},
   {
     $lookup:
       {
         from: "userclaims",
         localField: "_id",
         foreignField: "userId",
         as: "claims"
       }},{
       $unwind:"$claims"
       }
])

this query, when executed in mongodb terminal, yielded the right result

User.aggregate([
        {$match:{_id:mongoose.Types.ObjectId("5d5a8b83352b262670a4d47b")}},
        {
            $lookup:{
                from:"UserClaim",
                localField:"_id",
                foreignField:"userId",
                as:"claims"
            }
        },{
            $unwind:"$claims"
        }
    ])
    .exec().then((claims)=>{
        console.log(claims)
    }).catch((err)=>{
        console.log(err);
    })

this is the code that I've written in mongoose which is logging [].

Can you just pass mongoose.ObjectId instead of mongoose .Types.ObjectId? — Sunny Parekh
– Sunny Parekh, Commented Sep 19, 2019 at 6:27
@SunnyParekh it's throwing an error asking me to user mongoose.Types.ObjectId — sreeya chowdary
– sreeya chowdary, Commented Sep 19, 2019 at 6:40

Sudhakar · Accepted Answer · 2019-09-19 06:31:34Z

3

Try using mongo collection name(userclaims) instead of mongoose model in $lookup from

answered Sep 19, 2019 at 6:31

Sudhakar

5951 gold badge5 silver badges17 bronze badges

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

2 Comments

Samuel Over a year ago

It's a good culture to upvote an answer if it helped.

sreeya chowdary Over a year ago

I couldn't..as I've no required reputation :(

Collectives™ on Stack Overflow

Mongoose returns empty array while mongodb terminal returns the required results [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related