Django Model: Meta: how to have default ordering case-insensitive

Question

I am having a Django Model as shown below: I know that we can set the default ordering in the Meta class.

class Ingredient(models.Model):
    name = models.CharField(max_length=200,unique=True,null=False)
    slug = models.SlugField(unique=True)

    class Meta:
        ordering = ["name"]

As the ordering is set to name here. What i found is, it is ordering by case-sensitive. So how to make it case-insensitive

Possible duplicate of [django-orm case-insensitive order by](https://stackoverflow.com/questions/3409047/django-orm-case-insensitive-order-by) — Clément Denoix, Nov 17 '17 at 10:38
Its not duplicate. Here we are talking about the meta class. To know how to achieve that in Meta class. Or whether its possible or not — Santhosh, Nov 17 '17 at 18:03

score 11 · Answer 1 · answered Sep 25 '18 at 14:46

11

I tested with django 2.0.7 and using Upper works :

class Ingredient(models.Model):
    class Meta:
        ordering = [Upper('name'), ]
name = models.CharField(max_length=200,unique=True,null=False)

answered Sep 25 '18 at 14:46

Bryan Brancotte

311
3
7

2

from django.db.models.functions import Upper – Bryan Brancotte Sep 25 '18 at 14:47
Yep, confirmed this works in Django 2.2. You can use either `Upper` or `Lower`. – getup8 Jun 11 '19 at 18:49
Just an edit, I actually got errors in the Admin after making this change. Not entirely sure why, but had to remove it. – getup8 Jun 11 '19 at 22:15
Tested with Django==2.2.3, vanilla admin works fine. – Bryan Brancotte Aug 26 '19 at 09:12
It is/was a bug actually, see: https://code.djangoproject.com/ticket/30557 Don't think that's made it to the 2.2 stable release yet but it's in the Django 3.0 release. – getup8 Oct 09 '19 at 19:23

Clément Denoix · Accepted Answer · 2017-11-17T10:48:24.963

It's not possible set the default order to case-insensitive in the model meta options (source).

What you can do is use the order_by method of the QuerySet of your model:

from django.db.models.functions import Lower

Ingredient.objects.order_by(Lower('name'))

As stated already in this answer

To be able to have it as a default ordering (and avoid repeating the order_by method on each one of your querysets), you might want to create a custom Manager class for your Ingredient model:

# managers.py
from django.db.models.functions import Lower

class OrderedIngredientManager(models.Manager):
    def get_queryset(self):
        return super().get_queryset().order_by(Lower('name'))

# models.py
from .managers import OrderedIngredientManager

class Ingredient(models.Model):
    name = models.CharField(max_length=200,unique=True,null=False)
    slug = models.SlugField(unique=True)

    ordered_objects = OrderedIngredientManager()

So you can have all your QuerySet ordered:

Ingredient.ordered_objects.all()

Better even if this non-standard behaviour is placed in a custom Manager method order_by_ci(). — rollinger, Nov 17 '17 at 10:40
Thanks, I edited my answer to also explain how to add a custom `Manager` class with the default ordering. — Clément Denoix, Nov 17 '17 at 11:02

score 1 · Answer 3 · answered Feb 24 '20 at 19:01

1

You can use it by using F from django models

from django.db.models import F
class Ingredient(models.Model):
    class Meta:
        ordering = [F('name').asc(nulls_last=True)]

answered Feb 24 '20 at 19:01

DSAnup

23
7

Django Model: Meta: how to have default ordering case-insensitive

3 Answers3