Django .filter on same option with multiple possibilities

Question

I have a model of objects. I also have a list of options to filter results with. I'm not sure if there is an easy way to filter the objects in the model such that any object that matches any of the items in the filter list is returned. For example:

# returns all users with name starting with 'P'
usersWithPName = User.objects.filter(name__startswith = 'P')
# 3 letters to filter User model with
filterList = ['P', 'T', 'R'] 
# ideally would return all users with name starting with either 'P', 'T', or 'R'
usersWithPTRName = User.objects.filter(name__startswith = filterList) 

Is there any way to filter (in this case) the User model such that any object matching any one of the items in the filterList is returned?

Answer 1

This can be done with Q objects

from django.db.models import Q
usersWithPTRName = User.objects.filter(Q(name__startswith='P') |
                                       Q(name__startswith='T') |
                                       Q(name__startswith='R')) 

Also you can build Q filters at runtime:

filterList = ['P', 'T', 'R']
query = Q()
for letter in filterList:
    query = query | Q(name__startswith=letter)
usersWithPTRName = User.objects.filter(query)

Answer 2

You can use python reduce and operator builtins:

import operator
from functools import reduce

from django.db.models import Q

values = ["blue", "green", "brown"]

# or condition
conditions = reduce(operator.or_, [Q(**{"categories__slug": value}) for value in values])

# and condition
conditions = reduce(operator.and_, [Q(**{"categories__slug": value}) for value in values])

queryset = queryset.filter(conditions)