The issue lies in specifying ForeignKey fields (state, district, and
taluka) within the search_fields. ForeignKey fields cannot be searched
using 'icontains' because it requires a direct string comparison. Instead,
you can search based on the related field's attributes.
To resolve the error, you need to change the search_fields attribute to
search based on related fields' attributes. Assuming State, District, and
Taluka models have a field named name, you can update the search_fields as
follows:
search_fields = ('state__name', 'district__name', 'taluka__name', 'center',)
This modification will search for the related fields' name attributes,
allowing you to perform a case-insensitive substring search on those fields.
Remember to import the related models (State, District, and Taluka) at the
top of your admin.py file for the updated search_fields to work correctly.
On Thu, May 18, 2023 at 2:01 PM Ravindra Magar <ravikrs...@gmail.com> wrote:
> i am getting this error when i try to search in admin panel
>
> FieldError at /admin/school/center/
> Unsupported lookup 'icontains' for ForeignKey or join on the field not
> permitted.
>
> admin.py
> @admin.register(Center)
> class CenterAdmin(ImportExportModelAdmin, admin.ModelAdmin):
> list_display = ('id', 'state', 'district', 'taluka', 'center',)
> list_filter = ('state', 'district', 'taluka','center')
> search_fields = ('state','district', 'taluka','center',)
>
> model.py
> class Center (models.Model):
>
> state = models.ForeignKey(State, on_delete=models.CASCADE)
> district = ChainedForeignKey(District,
> chained_field='state',
> chained_model_field='state',show_all=False,
> auto_choose=True, sort=True)
> taluka = ChainedForeignKey(Taluka,
> chained_field='district',
>
> chained_model_field='district',show_all=False, auto_choose=True, sort=True)
>
>
> center = models.CharField(max_length=200)
>
> def str(self):
> return self.center
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to django-users+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/django-users/CAHMymCAkUmAc%3DGiG2mxmfNJLbT%3DYY7XwtCqsdE5m4M_Lr-hfVA%40mail.gmail.com
> <https://groups.google.com/d/msgid/django-users/CAHMymCAkUmAc%3DGiG2mxmfNJLbT%3DYY7XwtCqsdE5m4M_Lr-hfVA%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAMJ3z%3D18pL8d5OvNyem4PZes-a63voeKARXExj%3D36vJkrQJdyw%40mail.gmail.com.
