Mongoose Sort by an object's object value

Question

I have been writing a small node application and part of the query is sorting by the number of likes an object has, like this :

likes      : { num: { type: Number, default: 0 }, IDs:[Number]...

and the sort query:

Object.find().sort({likes : 'desc'};).execFind(function(err, confessions){...

this doesnt sort by the number of likes (like I would like it to) instead it sorts by the most recently liked object.

How would I sort by likes.num? I cant seem to get it to work...

EDIT: Heres a mongo doc as requested

{ __v: 0,
    _id: 51703a470ef8e60000000002,
    name: 'Name',
    text: ' this is a fresh submission for  mongo to hold',
    comments: { commentData: [], num: 0 },
    removed: false,
    time: Thu Apr 18 2013 11:24:07 GMT-0700 (PDT),
    likes: { IDs: [ 100001810858894 ], num: 1 },
    dislikes: { IDs: [ 100001810858894 ], num: 1 } }

EDIT: Heres the whole query

exports.index = function (req, res) {
console.log(req.user);
var sortParams;
var sort = req.params.sortingMethod;
console.log(sort);
if (sort == 'newest'){
     sortParams = { time : 'asc'};
} else if (sort == 'oldest'){
     sortParams = { time : 'desc'};
} else if (sort == 'likes'){
     sortParams = {likes.num : 'desc'};
} else if (sort == 'dislikes'){
     sortParams = {dislikes.num :'desc'};
} else {
     sortParams = { time : 'desc'};
}

console.log(sortParams);

Confession.find().sort(sortParams).execFind(function(err, confessions){...

you need to sort by the actual number of likes - where is it stored in the document? Can you paste an actual document from mongo into your question? — Asya Kamsky
– Asya Kamsky, Commented Apr 18, 2013 at 23:09
what does the likes document represent? is num going to be the number of likes? Then you need to sort on "likes.num" — Asya Kamsky
– Asya Kamsky, Commented Apr 18, 2013 at 23:14
This breaks the entire app with an Unexpected token . error, I had tried this before with the same result. Also yes num is the number of likes — PBLC
– PBLC, Commented Apr 18, 2013 at 23:17

PBLC · Accepted Answer · 2013-04-19 02:00:10Z

6

The answer was to wrap the query parameters in quotes like Linda Quin suggested

sortParams = {'likes.num' : 'desc'};

answered Apr 19, 2013 at 2:00

PBLC

2592 silver badges12 bronze badges

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

2 Comments

Asya Kamsky Over a year ago

and like I said in the original answer and in its comment.

PBLC Over a year ago

Oh, im sorry, I now realize that you ment for me to include the quotes. Thank you very much for your help

Asya Kamsky · Accepted Answer · 2013-04-19 14:58:50Z

0

You are getting the results sorted by object's value - the problem is that the object is the full JSON document. What you actually want is sorting by value of the specific field within the object, in your case that would be "likes.num"

The quotes are to be included in the query:

 {"likes.num":-1}

edited Apr 19, 2013 at 14:58

answered Apr 18, 2013 at 23:15

Asya Kamsky

42.4k5 gold badges113 silver badges133 bronze badges

2 Comments

PBLC Over a year ago

This breaks the entire app with an Unexpected token . error, I had tried this before with the same result. Also yes num is the number of likes. sortParams = {likes.num : 'desc'}; SyntaxError: Unexpected token .

Asya Kamsky Over a year ago

You need to use double quotes around dot expressions. {"likes.num":-1}

Collectives™ on Stack Overflow

Mongoose Sort by an object's object value

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related