Django get a QuerySet from array of id’s in specific order

by

Since Django 1.8, you can do:

from django.db.models import Case, When

pk_list = [10, 2, 1]
preserved = Case(*[When(pk=pk, then=pos) for pos, pk in enumerate(pk_list)])
queryset = MyModel.objects.filter(pk__in=pk_list).order_by(preserved)

More Related Contents:

  1. Django Cookies, how can I set them?
  2. Django rest framework nested self-referential objects
  3. How to ‘bulk update’ with Django?
  4. Django REST Framework: adding additional field to ModelSerializer
  5. Use variable as dictionary key in Django template
  6. Django multiprocessing and database connections
  7. Caching query results in django
  8. Django delete FileField
  9. Raise a validation error in a model’s save method in Django
  10. Overriding admin css in django
  11. SocketException: OS Error: Connection refused, errno = 111 in flutter using django backend
  12. How can I get a favicon to show up in my django app?
  13. Django: show a ManyToManyField in a template?
  14. Django: ordering numerical value with order_by
  15. Access kwargs from a URL in a Django template
  16. How to register users in Django REST framework?
  17. How to do a multi-step form in Django?
  18. Example of Django Class-Based DeleteView
  19. Accelerate bulk insert using Django’s ORM?
  20. Pass request context to serializer from Viewset in Django Rest Framework
  21. Django: permission denied when trying to access database after restore (migration)
  22. UnicodeEncodeError: ‘ascii’ codec can’t encode character
  23. How can I upload and download files with graphene-django?
  24. Django give Error 500 for all static files like CSS and Images, when DEBUG is False
  25. Authorization Credentials Stripped — django, elastic beanstalk, oauth
  26. How to use if/else condition on Django Templates?
  27. Django query case-insensitive list match
  28. Django/DRF – 405 Method not allowed on DELETE operation
  29. django : Serving static files through nginx
  30. Django: Using F arguments in datetime.timedelta inside a query

Leave a Comment