How to filter a django queryset using case insensitive __in?

user_11144121 0
Viewed 67

I have a model:

class Skill(models.Model):
    name = models.CharField(max_length=120)
    icon = models.CharField(max_length=20)
    color = models.CharField(max_length=7)

I want to do the following filter, but case insensitive:

skill_names = ['Code Quality', 'Analytical Thinking', 'Productivity', 'Communication']
Skill.objects.filter(name__in=skill_names)
django-queryset django python
2 Answers

I had similar problem and this helped me

from operator import or_
from functools import reduce
from django.db.models import Q

skill_names = ['Code Quality', 'Analytical Thinking', 'Productivity', 'Communication']
skill_filter = reduce(
    or_, (Q(name__icontains=skill) for skill in skill_names)
)
Skill.objects.filter(skill_filter)
user_198355450

Try this:

from django.db.models import Q

skill_names = ['Code Quality', 'Analytical Thinking', 'Productivity', 'Communication']

query = Q()

for skill in skill_names:
    query |= Q(name__contains=skill)

Skill.objects.filter(query)
user_198263960
Related