> this dont work!
What doesn't work? Can you give me an example of what result you get
and what you are expecting?
Here's a simple example of how it should work:
# Without a limit
>>> cur = db.users.find({}, {"user": 1, "_id": 0}).sort("
user.name", pymongo.DESCENDING)
>>> list(cur)
[{u'user': {u'name': u'ross'}}, {u'user': {u'name': u'jesse'}},
{u'user': {u'name': u'bernie'}}]
>>> cur = db.users.find({}, {"user": 1, "_id": 0}).sort("
user.name", pymongo.ASCENDING)
>>> list(cur)
[{u'user': {u'name': u'bernie'}}, {u'user': {u'name': u'jesse'}},
{u'user': {u'name': u'ross'}}]
# With a limit.
>>> cur = db.users.find({}, {"user": 1, "_id": 0}).limit(1).sort("
user.name", pymongo.DESCENDING)
>>> list(cur)
[{u'user': {u'name': u'ross'}}]
>>> cur = db.users.find({}, {"user": 1, "_id": 0}).limit(1).sort("
user.name", pymongo.ASCENDING)
>>> list(cur)
[{u'user': {u'name': u'bernie'}}]