Skip and Limit on nested array element

Question

I want to apply skip and limit for paging in nested array of a document how can I perform this [Efficient Way]

My Document recored like

{
   "_id":"",
   "name":"",
   "ObjectArray":[{
       "url":"",
       "value":""
   }]
}

I want to retrieve multiple document and every document contain 'n' number of record.

I am using $in in find query to retrieve multiple record on basis of _id but how can i get certain number of element of ObjectArray in every document?

Satish Shinde · Accepted Answer · 2015-05-13 19:05:41Z

35

You can try like this -

db.collection.find({}, {ObjectArray:{$slice:[0, 3]}})

This will provide you records from 0..3

$slice:[SKIP_VALUE, LIMIT_VALUE]}

For your example:-

db.collection.find({"_id":""}, {ObjectArray:{$slice:[0, 3]}})

Here is the reference for MongoDB Slice feature. http://docs.mongodb.org/manual/reference/operator/projection/slice/

edited May 13, 2015 at 19:05

answered May 13, 2015 at 18:50

Satish Shinde

3,0061 gold badge26 silver badges41 bronze badges

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

1 Comment

Ashish Singh Over a year ago

Why doesn't this query work in Mongo Compass? Is there any alternative to write above query in Mongo Compass?

Collectives™ on Stack Overflow

Skip and Limit on nested array element

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related