SOLVED-Related Field got invalid lookup: icontains error in Django

In this tutorial I will show you how to solve this following error "Related Field got invalid lookup: icontains" in django python project.

CODE: admin.py

from django.contrib import admin
from .models import *

class ProductAdmin(admin.ModelAdmin):
  list_display = ('name', 'description')
  list_per_page=10
  search_fields=['name','category']

admin.site.register(Product, ProductAdmin)

Model.py:

class Category(models.Model):
    name=models.CharField(max_length=150,null=False,blank=False)
    image=models.ImageField(upload_to=getFileName,null=True,blank=True)
    description=models.TextField(max_length=500,null=False,blank=False)
    created_at=models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.name

class Product(models.Model):
    category=models.ForeignKey(Category,on_delete=models.CASCADE)
    name=models.CharField(max_length=150,null=False,blank=False)
    product_image=models.ImageField(upload_to=getFileName,null=True,blank=True)
    description=models.TextField(max_length=500,null=False,blank=False)
    created_at=models.DateTimeField(auto_now_add=True)

    def __str__(self):
        return self.name

This error is happening due to adding foreign key field in search_fields.

To Resolve this error:

To add foreign key field in search, use double-underscore and grab name field from the category model.

EDITEDED CODE:admin.py

from django.contrib import admin
from .models import *

class ProductAdmin(admin.ModelAdmin):
  list_display = ('name', 'description')
  list_per_page=10
  search_fields=['name','category__name']

admin.site.register(Product, ProductAdmin)

VIDEO GUIDE: