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
– Dominic Rodger, Commented Oct 13, 2010 at 12:44
well - yes, that would be possible, but does not solve the general problem. — schneck
– schneck, Commented Oct 13, 2010 at 12:47

Gareth Rees · Accepted Answer · 2012-03-12 21:08:09Z

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, 2012 at 21:08

Gareth Rees

66.1k10 gold badges139 silver badges166 bronze badges

answered Oct 13, 2010 at 12:59

baklarz2048

11k2 gold badges33 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mp0int Over a year ago

Since you are using iexact match, you do not neet to use <string>.lower() docs.djangoproject.com/en/1.2/ref/models/querysets/#iexact

schneck Over a year ago

This works, thank you. However, I would appreciate an __iin-operator in the Django ORM.

Collectives™ on Stack Overflow

Django __in lowercase

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related