multiple parameter mongodb query

Question

find the project that's the least expensive AND has the highest number of ratings AND has the highest average rating. is this the correct method to do it?

exports.getBestEconomicalProject = function(number, callback){  
    var result = ProjectModel.find().sort({averageCost: 1}, {ratingCount : -1}, {averageRating : -1}).select({_id: 1}).limit(number).exec(
            function(err, projects) {
                callback(null, projects)
            }
        );  
    return result;
}

are you storing averageCost and ratingCount and averageRating in your document? — Asya Kamsky
– Asya Kamsky, Commented Nov 28, 2012 at 16:30
sounds like an impossible problem - the least expensive project may have lowest number of ratings and have nowhere near the highest average rating - how do you reconcile that? — Asya Kamsky
– Asya Kamsky, Commented Nov 28, 2012 at 20:08

JohnnyHK · Accepted Answer · 2012-11-28 18:39:42Z

2

You need to combine all sort terms into a single object:

exports.getBestEconomicalProject = function(number, callback){  
    var result = ProjectModel.find()
        .sort({averageCost: 1, ratingCount : -1, averageRating : -1})
        .select({_id: 1})
        .limit(number)
        .exec(
            function(err, projects) {
                callback(null, projects)
            }
        );  
    return result;
}

Or use the string format for the sort:

exports.getBestEconomicalProject = function(number, callback){  
    var result = ProjectModel.find()
        .sort('averageCost -ratingCount -averageRating')
        .select({_id: 1})
        .limit(number)
        .exec(
            function(err, projects) {
                callback(null, projects)
            }
        );  
    return result;
}

answered Nov 28, 2012 at 18:39

JohnnyHK

313k70 gold badges632 silver badges479 bronze badges

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

2 Comments

bouncingHippo Over a year ago

is there a difference in performance between the 2, in terms of runtime for instance?

kboom Over a year ago

string version of sort worked for me - object version or array version didn't

Collectives™ on Stack Overflow

multiple parameter mongodb query

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