3 django model filterset with django-filter

user_19442116 0
Viewed 49

I have 3 different django models and I want to filter using django-filter. The ORM query I wrote below works without any problems, but how can I do this with django-filter (filters.FilterSet)?

Employee.objects.filter(companyrecord__company__cname__icontains="ompanyname")

THIS WORKS

it is work for me in ORM. But how can I do this in filter set. I wrote above what I want to do

My Models:

class Employee(models.Model):
    employee_name = models.CharField(...)

class CompanyRecord(models.Model):
    employee = models.ForeignKey(Employee)
    company = models.ForeignKey(Company)

class Company(models.Model):
    cname = models.CharField(...)

My FilterSet:

class EmployeeFilter(filters.FilterSet):
    full_name = filters.CharFilter(field_name="full_name", lookup_expr='icontains')

    class Meta:
        model = Employee
            fields = ['full_name']
django-filter django-rest-framework django-models django python
1 Answers

The field_name=… parameter [readthedocs.io] can accept a chain of field names, like when you filter. Indeed:

Field names can traverse relationships by joining the related parts with the ORM lookup separator (__). e.g., a product’s manufacturer__name.

So you can work with:

class EmployeeFilter(filters.FilterSet):
    full_name = filters.CharFilter(
        field_name="full_name", lookup_expr='icontains'
    )
    company_name = filters.CharFilter(
        field_name="companyrecord__company__cname", lookup_expr='icontains'
    )

    class Meta:
        model = Employee
        fields = ['full_name']

Then you thus filter with the company_name for that filter.

user_675790
Related