Say there are 10 records, I want records 3 & 4 in descending order.
q1 = ModelName.objects.order_by('id').filter(id__gte=3)[:2] # gives
the records I want but in ascending order
q2 = ModelName.objects.order_by('-id').filter(id__gte=3)[:2] # gives
the last 2 records (9 & 10) in correct order
q3 = ModelName.objects.order_by('id').filter(id__gte=3)[:2].order_by('-
id') # Assertion Error: cannot reorder query once a slice has been
taken
q4 = ModelName.objects.order_by('id').filter(id__gte=3)[:2].reverse()
# Same as q2
So can I get the correct records in the wrong order or incorrect
records in the right order. I think I need to use extra() but don't
know how exactly (I have read the docs and had a few attempts but the
results were as 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
-~----------~----~----~----~------~----~------~--~---
