I have a database with the following document structure:
{
"_id" : ObjectId("520bea012ab230549e749cff"),
"Day" : 1,
"Time" : 54,
"State" : "Vermont",
"Airport" : "BTV",
"Temperature" : 39,
"Humidity" : 57,
"Wind Speed" : 6,
"Wind Direction" : 170,
"Station Pressure" : 29.6,
"Sea Level Pressure" : 150
}
I need to find the most high 'Temperature' for each 'State' (i.e. e.g. there are 100 document with 'State':'Vermont') and add entry 'month_high':true into this document (that has the most high temperature)
Here is my code: http://pastebin.com/UbACLbSF
But when I run the program in shell I get the following error:
MongoError: Can't canonicalize query: BadValue bad order array [2]
You should be passing in an object, not an array
cursor.sort({"State": 1, "Temperature": -1});
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With