Django Order By Date, but have “None” at end?

by

Django 1.11 added this as a native feature. It’s a little convoluted. It is documented.

Ordered with only one field, ascending:

wo = Work_Order.objects.order_by(F('dateWORequired').asc(nulls_last=True))

Ordered using two fields, both descending:

wo = Work_Order.objects.order_by(F('dateWORequired').desc(nulls_last=True), F('anotherfield').desc(nulls_last=True))

More Related Contents:

  1. How to filter empty or NULL names in a QuerySet?
  2. Custom QuerySet and Manager without breaking DRY?
  3. Why does django’s prefetch_related() only work with all() and not filter()?
  4. Select DISTINCT individual columns in django?
  5. Raw SQL queries in Django views
  6. How to limit queryset/the records to view in Django admin site?
  7. Django: implementing JOIN using Django ORM?
  8. Django – filtering on foreign key properties
  9. Django query datetime for objects older than 5 hours
  10. Django: Does prefetch_related() follow reverse relationship lookup?
  11. django most efficient way to count same field values in a query
  12. how to write a query to get find value in a json field in django
  13. When saving, how can you check if a field has changed?
  14. How do I do an OR filter in a Django query?
  15. Django: How can I protect against concurrent modification of database entries
  16. How to express a One-To-Many relationship in Django?
  17. Setting the selected value on a Django forms.ChoiceField
  18. Django: Set foreign key using integer?
  19. django – get() returned more than one topic
  20. Django model: delete() not triggered
  21. Django accessing ManyToMany fields from post_save signal
  22. Dropdown in Django Model
  23. How to query Case-insensitive data in Django ORM?
  24. Django comparing model instances for equality
  25. How to select a record and update it, with a single queryset in Django?
  26. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  27. Django query case-insensitive list match
  28. Password field in Django model
  29. Django filter JSONField list of dicts
  30. Can a dictionary be passed to django models on create?

Leave a Comment