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?

Answer 1

Use Q.

Example:

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

Answer 2

Use the __in lookup:

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