generating a queryset by filtering for multiple values

Question

I'm trying to create a view that returns a queryset based on multiple values.

The pseudo code logic of what I'm trying to do is below.

Model.objects.filter(author = dave or author = steve)

can this be done in a single query? If not then what is the most efficient way of doing this?

catavaran · Accepted Answer · 2015-03-23 10:47:41Z

1

Use the __in lookup:

Model.objects.filter(author__in=['dave', 'steve'])

answered Mar 23, 2015 at 10:47

catavaran

45.7k8 gold badges104 silver badges89 bronze badges

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

2 Comments

Thereissoupinmyfly Over a year ago

Excellent. Ruddra suggested that I use Q but since I already have lists of values this seems more appropriate. Thanks.

mohammed wazeem Over a year ago

what if author__in =[queryset1, queryset2]. how to do in this case filtering a single field with multiple queryset values rather than string.plz help..

ruddra · Accepted Answer · 2015-03-23 10:48:06Z

1

Use Q.

Example:

Model.objects.filter(Q(author='Dave') | Q(author='Steve'))

answered Mar 23, 2015 at 10:48

ruddra

52.1k7 gold badges82 silver badges105 bronze badges

1 Comment

Thereissoupinmyfly Over a year ago

Thanks. I tested this and it worked but I chose the answer by catavaran because my values were already in lists.

Collectives™ on Stack Overflow

generating a queryset by filtering for multiple values

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related