I encountered a scenario where I need to query the database for a
list of names sorted by length. In SQL this is easy:
SELECT name from distributors_distributor ORDER BY LENGTH(name)
Instead of writing raw SQL in my view, I am doing this:
names = [x['name'] for x in Distributor.objects.values('name')]
names.sort(lambda x, y: len(x) - len(y))
Is there a better way of doing this? Or rather, is there a way to use
the QuerySet API to produce the equivalent of the SQL above?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
