Thanks
Em terça-feira, 7 de junho de 2016 01:21:09 UTC-3, Simon Charette escreveu:
>
> 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/61059ffb-32d9-4bab-a932-e48732f11083%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
