How to combine/merge more than one queryset in to single queryset django

Question

I have a queryset as below

entries = [<Entry: Entry got issues>, <Entry: Entry Latest entry>, <Entry: Entry now tested>]

Each object in the above queryset entries will have a queryset as below

for entry in entries:
    print entry.tags.all()

Result

[<Tag: published>, <Tag: tags>, <Tag: needs>, <Tag: be>, <Tag: issues>, <Tag: to>]
[<Tag: abcd>]
[<Tag: abcd>, <Tag: nothing>]

so i want to merge the above three querysets in the result on to a single queryset as below

[<Tag: published>, <Tag: tags>, <Tag: needs>, <Tag: be>, <Tag: issues>, <Tag: to>]
 <Tag: abcd>, <Tag: abcd>, <Tag: nothing> ]

So how to merge/combine three querysets in to one above in django ?

Aleister · Accepted Answer · 2013-09-03 10:10:52Z

3

Use the | operator. i.e queryset = queryset1 | queryset2 | queryset3 But you can also use the & operator to find intersection. You have to make sure that all the querysets return are of the same objects i.e Tag.

What you want to do basically is

queryset = entries[0].tags.all()
for entry in entries[1:]:
    queryset = queryset | entry.tags.all()

edited Sep 3, 2013 at 10:10

answered Sep 3, 2013 at 10:04

Aleister

15310 bronze badges

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

1 Comment

Shiva Krishna Bavandla Over a year ago

K but i am getting the querysets from the for loop as above, so how to merge them using | or & from for loop ?

Collectives™ on Stack Overflow

How to combine/merge more than one queryset in to single queryset django

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related