sorting nested documents with pymongo

Question

how do i sort nested documents:

produits = self.db.users.find({"email":email}, {"produit_up":1,"_id":0}).sort(("produit_up.namep"), pymongo.DESCENDING)

this dont work!

here is my schema:

user={
"pseudo":pseudo,
"email":email, 
"avatar":avatar_id
"produit_up":{
"namep":namep, 
"prix":prix, 
}
}

everything worked without sorting, i just use produits = self.db.users.find_one({"email":email})["produit_up"] and in my templates i just call :

{% for produit in list(produits) %}
{{ produit["namep"] }}  
{{ produit["prix"] }}
....
{% end %}

so how do i do the same if i use SORT and LIMIT and then return the namep for example or prix

score 1 · Answer 1 · answered Sep 05 '12 at 14:21

1

# find_one document with sort.
db.produit.find_one({"email": "email"}, { "produit_up" : 1,"_id" : 0 }, sort=[("produit_up.namep", 1)])

# find all document with sort and limit at last 10 document.
db.produit.find({"email": "email"}, { "produit_up" : 1,"_id" : 0 }, sort=[("produit_up.namep", 1)]).limit(10)

answered Sep 05 '12 at 14:21

Lujeni

356
2
10

thank you, but finally, it seems that it's only made using Agregate http://groups.google.com/group/mongodb-user/browse_thread/thread/1b38ecae19ef71af/abfb902771315456?lnk=gst&q=alabdelouahab#abfb902771315456 – Abdelouahab Pp Sep 06 '12 at 21:57

score 0 · Accepted Answer · edited May 23 '17 at 11:49

0

ok, the tip is to use the python list, and then, sort it with a key How do I sort a list of dictionaries by values of the dictionary in Python?

edited May 23 '17 at 11:49

Community

1
1

answered Sep 07 '12 at 21:44

Abdelouahab Pp

4,252
11
42
65

sorting nested documents with pymongo

2 Answers2