mongoose populate nested array with condition for array element

Question

I have an ArticleGroup which contains articles, models look like this

var ArticleGroup = new mongoose.Schema({
    articles:[{type:mongoose.Schema.Types.ObjectId,ref:'Article'}]
})

var Article = new mongoose.Schema({
    rates:[{
        uid:String,
        rate:Number //user's rate number to this article
    }]
})

now A USER (let's call him JACK) want to perform a query to ArticleGroup, populating articles in this group, selecting the rates filed

usually I do this

ArticleGroupModel
    .findById(articleGroupId)
    .populate('articles','rates')
    .select('articles')
    .exec((err, articleGroup) => {
         if (err) return next(err)
         //...
    })

but now I ONLY want JACK's rate if one article has JACK's rate, just return that article like this

{
    _id:"23jrf23orj89p3fwje4",
    rates:[{
        uid:"JACK's uid",
        rate:"JACK's rate number"
    }]
}

if one article has no JACK's rate, the article is still populated, but with an empty rates filed like this

{
     _id:"23jrf23orj89p3fwje4",
     rates:[]
}

Is there any way to do this?

styopdev · Accepted Answer · 2016-10-14 12:33:08Z

2

In order to obtain this result you should reconsider your data model with something like this:

ArticleGroup = new mongoose.Schema
    some details here ...

ArticleRate = new mongoose.Schema
    uid: String
    rate: Number

Article = new mongoose.Schema
    group:
        type: mongoose.Schema.ObjectId
        ref: 'ArticleGroup'
    rates:[ArticleRate]

And perform this kind of query:

Article
.find(group: groupId)
.populate({
   path: 'rates',
   match: { uid: { $in: { JACK_UID } } },
   select: 'rate'
 })
 .exec();

You could find more helpful informations within the Mongoose documentation.

edited Oct 14, 2016 at 12:33

styopdev

2,6744 gold badges37 silver badges55 bronze badges

answered Jul 12, 2016 at 9:20

rphonika

1,12110 silver badges12 bronze badges

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

1 Comment

Yangxiao Ou Over a year ago

Well, change data model is not very easy...But thank you for you solution, I'll consider it

Collectives™ on Stack Overflow

mongoose populate nested array with condition for array element

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related