Filter Django database for field containing any value in an array

Question

I have a django model and a field representing a users full name. My client wants me to set up a filter to search for a user based on an array of strings where all of them have to be case insensitive contained within the full name.

For example

If a users full_name = "Keith, Thomson S."

And I have a list ['keith','s','thomson']

I want to perform the filter equivalent of

Profile.objects.filter(full_name__icontains='keith',full_name__icontains='s',full_name__icontains='thomson') 

The problem is this list can be of dynamic size - so I do not know how to do this.

Anyone have any ideas?

Answer 1

Make successive calls to filter, like so:

queryset = Profile.objects.all() strings = ['keith', 's', 'thompson'] for string in strings:     queryset = queryset.filter(full_name__icontains=string) 

Alternatively you can & together a bunch of Q objects:

condition = Q(full_name__icontains=s[0]) for string in strings[1:]:     condition &= Q(full_name__icontains=string) queryset = Profile.objects.filter(condition)  

A more cryptic way of writing this, avoiding the explicit loop:

import operator # ... condition = reduce(operator.and_, [Q(full_name__icontains=s) for s in strings]) queryset = Profile.objects.filter(condition)