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 <[email protected]> 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 [email protected].
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/CAMJ3z%3D18pL8d5OvNyem4PZes-a63voeKARXExj%3D36vJkrQJdyw%40mail.gmail.com.
