Django: __in query lookup doesn’t maintain the order in queryset

by

Assuming the list of IDs isn’t too large, you could convert the QS to a list and sort it in Python:

album_list = list(albums)
album_list.sort(key=lambda album: album_ids.index(album.id))

More Related Contents:

  1. How can I combine two or more querysets in a Django view?
  2. How do I do an OR filter in a Django query?
  3. How to filter empty or NULL names in a QuerySet?
  4. Custom QuerySet and Manager without breaking DRY?
  5. Why does django’s prefetch_related() only work with all() and not filter()?
  6. Select DISTINCT individual columns in django?
  7. _set in Django for a queryset
  8. Raw SQL queries in Django views
  9. How to limit queryset/the records to view in Django admin site?
  10. Django: implementing JOIN using Django ORM?
  11. Django – filtering on foreign key properties
  12. How to create a Django queryset filter comparing two date fields in the same model
  13. Django Queryset with filtering on reverse foreign key
  14. How to dynamically provide lookup field name in Django query? [duplicate]
  15. Django lazy QuerySet and pagination
  16. Django: ManyToMany filter matching on ALL items in a list
  17. Django query datetime for objects older than 5 hours
  18. Django, query filtering from model method
  19. Django: Does prefetch_related() follow reverse relationship lookup?
  20. django most efficient way to count same field values in a query
  21. Django Order By Date, but have “None” at end?
  22. Django query case-insensitive list match
  23. Django queryset get exact manytomany lookup [duplicate]
  24. how to write a query to get find value in a json field in django
  25. What’s the difference between django OneToOneField and ForeignKey?
  26. How do I do a not equal in Django queryset filtering?
  27. Django ModelChoiceField: filtering query set and setting default value as an object
  28. Django ManyToMany model validation
  29. Multiple images per Model
  30. Django’s forms.Form vs forms.ModelForm

Leave a Comment