Chaining fields with Django Autocomplete light and Django Filters

Using Django Mystery Errors
1

Hello!

I am trying to use Django Filter (DF) together with Django Autocomplete light (DAL) and chain three fields before filtering, but for some reason I can’t make it work.

I have integrated DF with DAL:

class RoomFilter(FilterSet):
    
    country = ModelChoiceFilter(lookup_expr="iexact",
                                queryset=Country.objects.all(), 
                                widget=autocomplete.ModelSelect2(url="auth_app:country-autocomplete", attrs={"class": "form-control"}), 
                                label=_("Country"))
    region = ModelChoiceFilter(lookup_expr="iexact", 
                               queryset=Region.objects.filter(country__name__iexact=country),
                               widget=autocomplete.ModelSelect2(url="auth_app:region-autocomplete", attrs={"class": "form-control"}, forward=["country"]), 
                               label=_("Region"))
    city = ModelChoiceFilter(lookup_expr="iexact", 
                             queryset=City.objects.filter(region__name__iexact=region), 
                             widget=autocomplete.ModelSelect2(url="auth_app:city-autocomplete", attrs={"class": "form-control"}, forward=["region"]), 
                             label=_("City"))

    ethnicity = ChoiceFilter(method="filter_ethnicity", choices=Ethnicity.choices, label="Etnicitet", widget=forms.Select(attrs={"class": "form-control"}))
    
    age = RangeFilter(field_name="member__age", lookup_expr="exact", label="Age", widget=RangeWidget(attrs={"class": "form-control"}))
    
    class Meta():
        model = Room
        fields = ["country", "region", "city", "ethnicity", "age"]


    def filter_ethnicity(self, queryset, name, value):
        return queryset.filter(
            Q(member__profile__ethnicity=value) |
            Q(member__profile__homo_firstuser_ethnicity=value) |
            Q(member__profile__homo_seconduser_ethnicity=value)
        )

The ends points that I’m referring to in the URL are all working properly. I’m using them in another form (without DF) and it manages to chain the search.

For exampel, when I select a certain country, all the regions in that country are queried automatically. And when I select a certain region, all the cities within that regions is also queried properly.

It’s worth mentioning that the country, region and city fields have a ForeignKey relationship to DAL Country, Region and City models.

Have anyone managed to accomplish this?