Posts

Showing posts with the label db query

How to search multiple keywords over multiple columns in Django

Image
How to search for multiple keywords over multiple columns in Django. Seach a list values in Multipal columns. #search query 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) reference We belive you like this pealse comment if any issues