How to append multiple filter() queries into one variable

Question

If I have three different queries of a model how do i append them into one variable

x = AnswerModel.objects.filter(user= 'tim')

y = AnswerModel.objects.filter(user= 'paul')

z = AnswerModel.objects.filter(question= 'i like jam')

x = x.append(y)
x = x.append(z)

possible duplicate of How can I find the union of two Django querysets? — garnertb
– garnertb, Commented Jan 3, 2015 at 18:02
i dont want to combine them inside a filter query of a model, i need to do it using two variable x append y i plan to do it in a for loop — Sprig Mendle
– Sprig Mendle, Commented Jan 3, 2015 at 18:09

knbk · Accepted Answer · 2015-01-03 22:18:43Z

3

Use |:

x = AnswerModel.objects.filter(user= 'tim')
y = AnswerModel.objects.filter(user= 'paul')
z = AnswerModel.objects.filter(question= 'i like jam')

qs = x | y | z

Or, using django.db.models.Q:

x = AnswerModel.objects.filter(Q(user='tim') | Q(user='paul') | Q(question='i like jam')

Both methods will return all results from all querysets in a single queryset.

answered Jan 3, 2015 at 22:18

knbk

53.9k9 gold badges130 silver badges128 bronze badges

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

Comments

torm · Accepted Answer · 2015-01-03 19:08:01Z

1

You need chain.

from itertools import chain
x = list(chain(x, y, z))

answered Jan 3, 2015 at 19:08

torm

1,54615 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to append multiple filter() queries into one variable

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related