Django - How to sort queryset by number of character in a field

MyModel:

name = models.CharField(max_length=255)

I try to sort the queryset. I just think about this:

obj = MyModel.objects.all().sort_by(-len(name)) #???

Any idea?

Answers


you might have to sort that in python..

sorted(MyModel.objects.all(),key=lambda o:len(o.name),reverse=True)

or I lied ( A quick google search found the following)

MyModel.objects.extra(select={'length':'Length(name)'}).order_by('length')

The new hotness (as of Django 1.8 or so) is Length()

from django.db.models.functions import Length
obj = MyModel.objects.all().order_by(Length('name').asc())

You can of course sort the results using Python's sorted, but that's not ideal. Instead, you could try this:

MyModel.objects.extra(select={'length':'Length(name)'}).order_by('length')

You'll need to use the extra argument to pass an SQL function:

obj = MyModel.objects.all().extra(order_by=['LENGTH(`name`)']) 

Note that this is db-specific: MySQL uses LENGTH, others might use LEN.


Need Your Help

how to initialize time() object in python

python date datetime time strptime

I am trying to initialize a time object like this:

SignalR and MVC bundle

asp.net-mvc bundle signalr

I'm trying to use SignalR with MVC bundle, but having problem finding out how to include the /signalr/hubs script into the bundle. For now I have to insert the path in between jquery.signalR and my...