Hi Neto,
Ordering by expression (order_by(Lower('name')) is not supported yet but
it's
tracked as a feature request[1].
If we manage to allow transforms in `order_by()`[2] in the future you
should be
able to define a ['name__lower'] ordering in the future but until then you
have to use a combination of `annotate()` and `order_by()` on a custom
manager:
class PersonManager(models.Manager):
def get_queryset(self, *args, **kwargs):
queryset = super(PersonManager, self).get_queryset(*args, **kwargs)
return queryset.annotate(
name_lower=Lower('name'),
).order_by('name_lower')
class Person(models.Model):
name = models.CharField(_('name'), max_length=100)
objects = PersonManager()
Cheers,
Simon
[1] https://code.djangoproject.com/ticket/26257
[2] https://code.djangoproject.com/ticket/24747
Le lundi 6 juin 2016 19:21:32 UTC-4, Neto a écrit :
>
> It does not works:
>
> from django.db.models.functions import Lower
>
>
> class Person(models.Model):
>
> name = models.CharField(_('name'), max_length=100)
>
> class Meta:
> ordering = [Lower('name')]
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/be479f89-8b5f-4fc2-ad27-2e4e17316bec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
