MongoDb document sub array pagination

Question

I am storing post comments in a post, and the problem I am facing right now is that I cannot use limit with skip on an array of a document, since the users can post as many comments as they want, the array will be huge, So i wanted to paginate the comments.

is there a way to accomplish this?

is it possible to only retrieve like 10 comments per call?

thanks!

{
  id:0,
  ref:0,
  type: 'image',
  date: null,
  title: 'this is my title',
  comments:[
      {
        user : 'myUser',
        text : 'text'
      },
      {
        user : 'myUser2',
        text : 'text2'
      }
}

popo joe · Accepted Answer · 2014-02-07 15:34:15Z

1

Found the solution: in projections just do :

projection("{comments : {$slice:[#,#]}}",start,size)

answered Feb 7, 2014 at 15:34

popo joe

9101 gold badge9 silver badges25 bronze badges

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

2 Comments

dReAmEr Over a year ago

what was the exact syntax did you use there?

Pratik Solanki Over a year ago

Were you able to get a solution and how did it work? can you please share it

Collectives™ on Stack Overflow

MongoDb document sub array pagination

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related