Django: ordering numerical value with order_by

by

If you’re sure there are only integers in the field, you could get the database to cast it as an integer via the extra method, and order by that:

MyModel.objects.extra(
    select={'myinteger': 'CAST(mycharfield AS INTEGER)'}
).order_by('myinteger')

More Related Contents:

  1. Django admin: how to sort by one of the custom list_display fields that has no database field
  2. Extending the User model with custom fields in Django
  3. How can I get the full/absolute URL (with domain) in Django?
  4. Django stops working with RuntimeError: populate() isn’t reentrant
  5. How to resolve “django.core.exceptions.ImproperlyConfigured: Application labels aren’t unique, duplicates: foo” in Django 1.7?
  6. Creating a extended user profile
  7. Django 1.11 Annotating a Subquery Aggregate
  8. How to update an object from edit form in Django?
  9. selenium.common.exceptions.InvalidCookieDomainException: Message: invalid cookie domain while executing tests in Django with Selenium
  10. Track the number of “page views” or “hits” of an object?
  11. Django Static Files Development
  12. Django Broken pipe in Debug mode
  13. Tying in to Django Admin’s Model History
  14. django class-based views with inline model-form or formset
  15. How to automate createsuperuser on django?
  16. Overriding AppConfig.ready()
  17. How can I call a custom Django manage.py command directly from a test driver?
  18. Add class to form field Django ModelForm
  19. “No ‘Access-Control-Allow-Origin’ header is present on the requested resource” in django
  20. django dynamically filtering with q objects
  21. how to show datepicker calendar on datefield
  22. Order by count of a ForeignKey field?
  23. Django {% static ‘path’ %} in javascript file
  24. Byte Ranges in Django [closed]
  25. Django ORM: Group by and Max
  26. Nginx connection reset, response from uWsgi lost
  27. Django queryset get exact manytomany lookup [duplicate]
  28. Django / Comet (Push): Least of all evils?
  29. 110: Connection timed out (Nginx/Gunicorn)
  30. How to show related items using DeleteView in Django?

Leave a Comment