Filter Django queryset with multiple variables

Question

I would like to pass one or many GET variables to filter a queryset. I have tried the following code to create a dictionary of the variables and apply the filter, but testing with two variables it appears to only be filtering on the final dictionary variables.

for k,v in mydict.items():
    qs = mymodel.objects.filter(**{"%s__contains" % k: v})

Can anyone point me in the right direction as to where I am going wrong?

Selcuk · Accepted Answer · 2018-11-22 00:26:43Z

2

You are creating a new queryset in each iteration from scratch instead of chaining them. Try changing your code to:

qs = mymodel.objects.all()
for k, v in mydict.items():
    qs = qs.filter(**{"%s__contains" % k: v})

answered Nov 22, 2018 at 0:26

Selcuk

60.1k12 gold badges114 silver badges119 bronze badges

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

Collectives™ on Stack Overflow

Filter Django queryset with multiple variables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related