I want to be able to input a list of strings like so:
["searchterm1", "searchterm2", "searchtermN"]
And output all rows from the database where "searchterm1" matches one of the columns OR "searchterm2" matches one of the columns and so on.
Is there a way to do so?
from django.db.models import Q
def search(request):
list_ = ["searchterm1", "searchterm2", "searchtermN"]
q_object = Q(title__icontains=list[0]) | Q(description__icontains=list[0])
for item in list_[1:]:
q_object.add((Q(title__icontains=item) | Q(description__icontains=item)), q_object.connector)
queryset = Product.objects.filter(q_object)