Not paginated the result for $group, $facet, or even $unwind

[mandaputtra]

Just tried this aggregation with, $unwind $group or $facet it always serializes the docs to be one.

    Chat.aggregate([
      { $match: { roomId: unique } },
      { $unwind: '$message' },
      { $sort: { 'message.time': -1 } },
      { $group: { _id: "$_id", message: "$message.text" } } 
    ])

[aravindnc]

@mandaputtra I will review it and get back.

[mandaputtra]

Just for info, I get around this issue with $facet

// assume that page and limit are query params contains number 
{
  $facet: {
     metadata: [{ $count: 'total' }, { $addFields: { page: page } }],
     data: [
       { $skip: page === 1 ? 0 : (page - 1) * limit },
           { $limit: limit }
      ]}
}

[aravindnc]

@mandaputtra Glad to hear that.

[mandaputtra]

I'll do some test in my free time, and maybe if this was bug ill try to pull request. But that could be a major change. Lest see..

[aravindnc]

@mandaputtra Appreciate it. You're awesome!

[gezimapi]

hi ,

i am having the same problem . it always serializes all the docs in the collection one by one not the result in aggregate.

[mandaputtra]

@gezimapi I custom paginate it, with $facet. I wrote an articele here.

It will be a major change if the feature merged,

[aravindnc]

Thanks @mandaputtra