Opened 17 years ago

Closed 17 years ago

Last modified 16 years ago

#6604 closed (fixed)

Custom sort of QuerySet() as list

Reported by: Alexander Nesterov <alexanderad@…> Owned by: nobody
Component: Database layer (models, ORM) Version: dev
Severity: Keywords: queryset, sort
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

In my table I have values like: 'test1', 'test2', 'test111' and so on, and need to sort them. ORDER BY statement sorts them "wrongly" as strings:
'test2' > 'test4' - false but 'test4' > 'test12' - true.
I can sort this values manually, using list and custom cmp function, but in this situation my sort function will return list instead of QuerySet object, that I need for my ModelChoiceField.
Is there any way to sort QuerySet items as list? (list.sort(cmp=...))
Thanks.

Change History (5)

comment:1 by Malcolm Tredinnick, 17 years ago

Resolution: invalid
Status: newclosed

Please ask questions like this on the django-users list, not in the bug reporting system.

comment:2 by Luke Plant, 16 years ago

Resolution: invalidfixed

(In [7736]) newforms-admin: Fixed #6604 - removed useless code. Thanks Petr Marhoun, programmerq

comment:3 by Luke Plant, 16 years ago

Oops, typo in commit message accidentally closed this. mea culpa.

comment:4 by Collin Anderson, 16 years ago

([7736] actually closed #6004)

comment:5 by Paul Winkler, 16 years ago

For anyone who finds this bug while searching for a way to solve the problem,
see this thread for a solution:
http://groups.google.com/group/django-users/browse_thread/thread/341926c0daf90862

Note: See TracTickets for help on using tickets.
Back to Top