MongoDB sorting by nested object value

Question

I'm trying to sort results based on the values of a nested object. Using node-mongodb-native, I'm doing this:

    this.collection.find({
          "_id": ObjectID(item_id) }, 
        { "items": 1 },
        { sort : { items.date : 1 }
    }, function(err, result) {
        if (err) {
            callback(err);
        } else {
            callback(null, result);
        }
    });

I get an unexpected token error for items.date.

items is an array of objects. Some documents it's an empty array, others it contains data, which contains a date field.

Thank you!

JohnnyHK · Accepted Answer · 2012-08-20 02:16:49Z

64

When using dot notation you need to put the key value in quotes, so your sort object should look like this instead:

sort: {
    "items.date" : 1
}

That will sort ascending by minimum date value in each doc's items array

answered Aug 20, 2012 at 2:16

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

2 Comments

Rob Allsopp Over a year ago

i think this will only use the first date in the array for sorting. so if you wanted to sort descending, and your later dates were appended to the end rather than inserted to the beginning, your sort would be incorrect.

Naveed Over a year ago

@RobAllsopp how do you fix that? I sorted descending and the documents that dont have the nested value are displayed on top

Collectives™ on Stack Overflow

MongoDB sorting by nested object value

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