MongoDB retain order of array for $in operator

Asked Mar 09 '15 at 05:32

Active Mar 09 '15 at 05:32

Viewed 47 times

I want to find a bunch of users in order using an array of ids. The array might look like this:

var array = [ '123', '42312124', '1231aoicali3' ];

This list is ordered, and I really want the users to appear in that order. I've noticed that reordering the same list does not reorder the documents I receive. Is there any way I can specify the order? The query I'm using right now is:

User.find({ '_id': { $in: array }})

I'm using NodeJS with Mongoose if that makes any difference.

asked Mar 09 '15 at 05:32

ritmatter

3,448
4
24
43

You want to order the users and store it MongoDB? – thefourtheye Mar 09 '15 at 05:33
No I want to query the users and retain the order of the IDs. – ritmatter Mar 09 '15 at 05:34
1

`I've noticed that reordering the same list does not reorder the documents I receive` - What do you mean by this? – thefourtheye Mar 09 '15 at 05:35
This question has already been answered. I meant that no matter what the order is of the array, the documents returned will always be in the same order – ritmatter Mar 09 '15 at 05:36

MongoDB retain order of array for $in operator

0 Answers0