Mongoose match different fields when populated

Asked Feb 20 '18 at 05:30

Active Feb 20 '18 at 08:26

Viewed 151 times

I have a model(User), which has two ref objects(Training, Evaluation), each ref object holds some content with results on different dates.

When I populate, I want to filter data of "Training" & "Evaluation" results at specific dates.

I am trying something like this, please help

Mnguser.find({})
    .populate({
        path: 'Training Evaluation',
        match: {
            'Training.trainDate':{
                $gt: firstDay,
                $lt: lastDay
            },
            'Evaluation.evalDate':{
                $gt: firstDay,
                $lt: lastDay
             }
        }
    })
    .then(res){results}

Note: Training & Evaluation are an array of objects, above is just a view of my thought.

Thanks in advance

asked Feb 20 '18 at 05:30

foxenn_pro

Please read this question-https://stackoverflow.com/questions/11303294/querying-after-populate-in-mongoose – deepak thomas Feb 20 '18 at 05:44
Possible duplicate of [Querying after populate in Mongoose](https://stackoverflow.com/questions/11303294/querying-after-populate-in-mongoose) – deepak thomas Feb 20 '18 at 05:56
Hi thanks for your comment, but here i have an array of objects, i want to filter date in each of the ref array objects. – foxenn_pro Feb 20 '18 at 06:08
Here i am dealing with two different population and different field names of each populated array objects – foxenn_pro Feb 20 '18 at 06:12
1

can you share yours schema's ? – Abdullah Khan Feb 20 '18 at 09:39
could you solve it? – nicogaldo Jul 26 '18 at 21:58
see this https://stackoverflow.com/questions/36400361/i-want-to-find-populate-or-search-mongoose – nicogaldo Jul 26 '18 at 22:15

Mongoose match different fields when populated

0 Answers0