Django: Adding “NULLS LAST” to query

by 
from django.db.models import F  
MyModel.objects.all().order_by(F('price').desc(nulls_last=True))

This functionality has been added to Django 1.11.

https://docs.djangoproject.com/en/dev/releases/1.11/

Added the nulls_first and nulls_last parameters to Expression.asc()
and desc() to control the ordering of null values.

Reference for Django 3.1: https://docs.djangoproject.com/en/3.1/ref/models/expressions/#using-f-to-sort-null-values

More Related Contents:

  1. Getting the SQL from a Django QuerySet [duplicate]
  2. LEFT JOIN Django ORM
  3. How to see the raw SQL queries Django is running?
  4. How to log all sql queries in Django?
  5. How to perform OR condition in django queryset?
  6. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  7. What is the best way to access stored procedures in Django’s ORM
  8. How to quote a string value explicitly (Python DB API/Psycopg2)
  9. How to delete a record in Django models?
  10. Does the django-rest-framework provide an admin site to manage models?
  11. How to convert JSON data into a Python object?
  12. Django, creating a custom 500/404 error page
  13. How do I force Django to ignore any caches and reload data?
  14. ImproperlyConfigured: You must either define the environment variable DJANGO_SETTINGS_MODULE or call settings.configure() before accessing settings
  15. Using a WHERE ___ IN ___ statement
  16. Generating a Random Hex Color in Python
  17. Trying to parse `request.body` from POST in Django [duplicate]
  18. Elegant setup of Python logging in Django
  19. In Django, how do I check if a user is in a certain group?
  20. Django and query string parameters
  21. Django circular model reference
  22. Heroku fails to install pywin32 library
  23. Running django tutorial tests fail – No module named polls.tests
  24. Simple approach to launching background task in Django
  25. Django 1.9 deprecation warnings app_label
  26. Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events
  27. Good ways to sort a queryset? – Django
  28. Django — Conditional Login Redirect
  29. How do I access dictionary keys that contain hyphens from within a Django template?
  30. How to use custom AdminSite class?

Leave a Comment