Django Querysets & dynamic string filtering

Question

It seems that __in is only suitable for integers. I am trying to filter by strings.

I've tried this but it does not work.

    groups = ['foo', 'bar'] 
    args = []
    for group in groups:
        args.append(Q(name=group))
    group_ids = Group.objects.filter(*args)

What is the preferred way to dynamically filter a Django queryset using strings?

What makes you say __in is only suitable for integers? It works just fine for strings. — Mark Lavin
– Mark Lavin, Commented Feb 2, 2014 at 17:15
@Mark is correct. See my answer below if you need something other than an exact match (e.g. iexact, contains). — Kevin Christopher Henry
– Kevin Christopher Henry, Commented Feb 2, 2014 at 17:21
@Mark: My bad. You are right. If you post your comment as an answer I will accept it. — dan-klasson
– dan-klasson, Commented Feb 2, 2014 at 17:27

Kevin Christopher Henry · Accepted Answer · 2014-02-02 17:21:36Z

2

Your query is doing an and of all those values, and I assume you want an or? Try:

query = Q(name=groups[0])
for group in groups[1:]:
    query |= Q(name=group)

group_ids = Group.objects.filter(query)

edited Feb 2, 2014 at 17:21

answered Feb 2, 2014 at 17:13

Kevin Christopher Henry

49.7k8 gold badges125 silver badges112 bronze badges

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

Comments

Mark Lavin · Accepted Answer · 2014-02-02 17:36:49Z

0

__in can be used for strings as it translates to a SQL IN operation. Whether or not it is case-sensitive my depend on your table/column collation.

answered Feb 2, 2014 at 17:36

Mark Lavin

25.2k5 gold badges79 silver badges72 bronze badges

Collectives™ on Stack Overflow

Django Querysets & dynamic string filtering

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related