Getting the highest value of a column in MongoDB

ruby mongodb mongodb-ruby
roloenusa picture roloenusa · Jan 21, 2011 · Viewed 38.1k times · Source

I've been for some help on getting the highest value on a column for a mongo document. I can sort it and get the top/bottom, but I'm pretty sure there is a better way to do it.

I tried the following (and different combinations): 

transactions.find("id" => x).max({"sellprice" => 0})

But it keeps throwing errors. What's a good way to do it besides sorting and getting the top/bottom?

Thank you!

Answer

Michael Papile picture Michael Papile · Jan 21, 2011

max() does not work the way you would expect it to in SQL for Mongo. This is perhaps going to change in future versions but as of now, max,min are to be used with indexed keys primarily internally for sharding.

see http://www.mongodb.org/display/DOCS/min+and+max+Query+Specifiers

Unfortunately for now the only way to get the max value is to sort the collection desc on that value and take the first. 

transactions.find("id" => x).sort({"sellprice" => -1}).limit(1).first()

Related questions

Ruby group hashes by value of key

I have an array, which is output by a map/reduce method performed by MongoDB, it looks something like this: [{"minute"=>30.0, "hour"=>15.0, "date"=>5.0, "month"=>9.0, "year"=>2011.0, "type"=>0.0, "count"=>299.0}, {"minute"=>30.0, "hour"=>15.0, "date"=>5.0, "…

Read More
What is the length maximum for a string data type in MongoDB used with Ruby?

I wasn't able to find any information on the max length for a string data type in MongoDB on the main mongodb.org site. I'm coming from a relational database background and there are usually max lengths. Thank you!

Read More
Querying last 30 days date range with Mongoid and Ruby?

How do I go about querying a date range (of say the last 30 days from now) with Mongoid and Ruby? I need to end up with an array or hash like the following: { 15 => 300, 14 => 23, 13 => 23 ... 30 => 20 # Goes over into …

Read More