Mongoose: Filter collection based on values in another collection

Question

Consider documents that contain an arrays of ID of another collection, how can I find documents applying a filter based on the related collection using mongoose? I can't find my error

  Installation.aggregate(                        
                    [
                          // Stage 1
                          {
                                $lookup: {
                                      from: "users",
                                      localField: "_id",
                                      foreignField: "_id",
                                      as: "Users"
                                }
                          },

                          // Stage 2
                          {
                                $unwind: {
                                      path: "$Users"
                                }
                          },
                          // Stage 3
                          {
                                $match: 
                                      {"Users.Email1" : "test@test.com"}
                                
                          }, 
                          {
                                $sort: { _id: -1 }
                          },
                          {
                                $limit: 10
                          }                            
                    ]
              ,function (err, installations) {
                    
                   console.log(installations); //<<<<< Empty
                    /*
                    Installation.populate( 'Parent', '_id Email1','Company'), function(err,results) {
                          Installation.count(filter).exec(function (err, count) {
                                res.send({ success: true, results: installations, total: count });
                          });
                    };
                    */                                                             
              });

it would be easier to answer if you put some sample data with your question — Ashh, Jul 03 '18 at 10:17
Put in values for **filter, sorting, _count, req.params.page, req.param.count**? — Harshal Yeole, Jul 03 '18 at 10:23
Can you add `**console.log(err)** before console.log(installations);??? — Harshal Yeole, Jul 03 '18 at 11:19
Also, you cannot populate data returned from aggregate, you can add more operations of lookup for join and project to project the fields you want to, — Harshal Yeole, Jul 03 '18 at 11:20
it works ! localField was the error..thank you so much! for the populate I've create another post! — Gelso77, Jul 03 '18 at 11:42

Harshal Yeole · Accepted Answer · 2018-07-03T10:24:39.850

3

You can do this using aggregate query:

db.collectionA.aggregate(

    // Pipeline
    [
        // Stage 1
        {
            $lookup: {
                from: "collectionB",
                localField: "_id",
                foreignField: "_id",
                as: "collectionBData"
            }
        },

        // Stage 2
        {
            $unwind: {
                path : "$collectionBData"
            }
        },

        // Stage 3
        {
            $match: {
                "collectionBData.email": "your@email.address"
            }
        },

    ]

);

Hope this solves your query.

Also, in Mongo, we use naming conventions as collections instead of table and _id instead of id.

edited Jul 03 '18 at 10:24

answered Jul 03 '18 at 07:50

Harshal Yeole

4,812
1
21
43

Thank you so much but i don't where should i put it ? into the schema? – Gelso77 Jul 03 '18 at 08:35
No it’s a query. – Harshal Yeole Jul 03 '18 at 08:37
Should i use aggregate instead find ? – Gelso77 Jul 03 '18 at 08:55
‘COLLECTIONNAME.aggregate()’ that’s all – Harshal Yeole Jul 03 '18 at 09:09
You can add sorting in aggregate query. Aggregate is replacement to find – Harshal Yeole Jul 03 '18 at 09:09
ok do you mean that inside the aggregate I can put sort, limit , skip and popuplate ? – Gelso77 Jul 03 '18 at 09:13
Yes you can put sort, limit and skip and you can not use populate. – Harshal Yeole Jul 03 '18 at 09:57
First, use my query and see if you are getting your results and then you can add more operations. – Harshal Yeole Jul 03 '18 at 10:00
thank you so much it's not easy :-( I've update my code on the question – Gelso77 Jul 03 '18 at 10:20
So my answer wasn't any useful? – Harshal Yeole Jul 03 '18 at 10:21
your answer is amazing !!! I really appreciate, I've just put my code on the question so you can see where is my error – Gelso77 Jul 03 '18 at 10:24
Okay, add few values in the code which I have asked on your question's comment section. – Harshal Yeole Jul 03 '18 at 10:25

Mongoose: Filter collection based on values in another collection

1 Answers1