|
Hi Eran -
which version of mongodb are you using? For 3.0, the addSpecial ("$orderby") should work:
> db.products.find( { }, { item: 1, qty: 1, _id: 0 } )._addSpecial( "$orderby", { qty: -1 } )
|
{ "item" : "card", "qty" : 500 }
|
{ "item" : "Galaxi 3", "qty" : 50 }
|
{ "item" : "iPhone 4", "qty" : 30 }
|
{ "item" : "iPhone 5s", "qty" : 20 }
|
However, starting in 3.2, use sort() method:
> db.products.find( { }, { item: 1, qty: 1, _id: 0 } ).sort( { qty: -1 } )
|
{ "item" : "card", "qty" : 500 }
|
{ "item" : "Galaxi 3", "qty" : 50 }
|
{ "item" : "iPhone 4", "qty" : 30 }
|
{ "item" : "iPhone 5s", "qty" : 20 }
|
|