Django __in lowercase

Question

I'm using django-taggit, which handles the attachment of tags to arbitrary content types. I imported a large tag list, which contains many uppercase words, as well as lowercase words.

Now, I' trying to get objects of another class containing a set of tags, but I want to compare case insensitively. When I do this:

Media.objects.filter(tags__name__in=['tag1', 'tag2'])

objects containing e.g. the tag "Tag1" are not found, only those ones with "tag1" or "tag2".

Is there any possibility in the django orm to do something like:

Media.objects.filter(tags__name__iin=['tag1', 'tag2'])

that acts like "icontains"?

Sounds like your better bet is to spin through your tags and convert them all to lowercase. — Dominic Rodger, Oct 13 '10 at 12:44
well - yes, that would be possible, but does not solve the general problem. — schneck, Oct 13 '10 at 12:47

score 3 · Accepted Answer · edited Mar 12 '12 at 21:08

3

There is no easy way to do it. I'm not 100% sure, You can try something like this for your problem.

from django.models import Q

q = Q()
for tag in tags.split():
    q |= Q(tags__name__iexact=tag)

Media.objects.filter(q)

edited Mar 12 '12 at 21:08

Gareth Rees

64,967
9
133
163

answered Oct 13 '10 at 12:59

baklarz2048

10,699
2
31
37

Since you are using iexact match, you do not neet to use .lower() http://docs.djangoproject.com/en/1.2/ref/models/querysets/#iexact – Mp0int Oct 13 '10 at 13:08
This works, thank you. However, I would appreciate an __iin-operator in the Django ORM. – schneck Oct 13 '10 at 13:38

Django __in lowercase

1 Answers1

Linked