How to search multiple keywords over multiple columns in Django

By

How to search for multiple keywords over multiple columns in Django. Seach a list values in Multipal columns.

search in multiple colum image


#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

Comments

Post a Comment

Popular posts from this blog

AttributeError: Got AttributeError when attempting to get a value for field `field_name` on serializer `ModelSerializer`.

By
The serializer field might be named incorrectly and not match any attribute or key on the `QuerySet` instance. Original exception text was: 'QuerySet' object has no attribute 'name'. Solution: just add many=True on serializer class instance Replace: serializer = ModelSerializer(queryset) to: serializer = ModelSerializer(queryset, many=True) return Response(serializer.data)
Read more

Use Djoser In Api's For Authentication In Django

By
Hint --- Please make sure you setup EmailBackend already setup another wise this is not work  1. Install some library *  pip install -U djoser   *  pip install -U djangorestframework_simplejwt *  pip install -U social-auth-app-django 2.  Add This  in Your  INSTALLED_APPS in setting.py file      'rest_framework' ,      'rest_framework.authtoken' ,     'djoser'   3.  Add url in urls.py in project url file urlpatterns = [ path( 'admin/' , admin.site.urls) ,-- default path( '' , include( 'editor.urls' )) , -- your apps url path( '' , include( 'djoser.urls' )) , -- given urls in djoser path( '' , include( 'djoser.urls.jwt' )) , -- for jwt path( '' , include( 'djoser.urls.authtoken' )) , -- for login, logout 4. Add Rest frame Work in setting.py file REST_FRAMEWORK = { 'DEFAULT_AUTHENTICATION_CLASSES' : [ 'rest_framework.authentication.BasicAuthentication' , ...
Read more

DRF: Incorrect type. Expected pk value, received str - ManyToManyField in Django APIs

By
How to fix if Incorrect type. Expected pk value, received str -  ManyToManyField in Django Rest Framework 1. models.py class Cart(models.Model): user = models.ForeignKey(CustomUser, on_delete=models.CASCADE) events = models.ManyToManyField(Event, null=True, blank=True) resourse_files = models.ManyToManyField(ResourseDetail, null=True, blank=True) status = models.BooleanField(default=True) created_at = models.DateTimeField(auto_now_add=True) updated_at = models.DateTimeField(auto_now=True) 2. serializers.py class CartSerializer(serializers.ModelSerializer): class Meta: model = Cart fields = '__all__' or class CartSerializer(serializers.ModelSerializer): events = EventSerializer(many=True) resourse_files = ResourseDetailSerializer(many=True) class Meta: model = Cart fields = '__all__' 3. views.py class CartView(viewsets.ModelViewSet): '''Cart api view /cart/''' ...
Read more