hi all, i have basically the same problem as this guy on stackoverflow: http://stackoverflow.com/questions/151195/possible-to-use-sql-to-sort-by-date-but-put-null-dates-at-the-back-of-the-results
i have a ticket-application where tickets have a deadline (which is optional an can therefore be null) and when i display my tickets the ones with no deadline should show up last. but mysql puts null-values first. i was looking at django's documentation of extra() to see if i can adapt the solution presented on stack overflow but i am unsure if it is really possible? at least the given examples for order_by are less complex. this is what looks like a solution in mysql's sql syntax: ORDER BY CASE WHEN myDeadline IS NULL THEN 1 ELSE 0 END, myDeadline; or is there even an easier way to accomplish what i want using django's orm? or is my best approach to create a calculated field which i update "on save" and then use this for sorting? thanks! andreas -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@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.
