Queries on multiple fields, each with a custom method, with django-filter

Question

I have this filter:

class MsTuneFilter(django_filters.FilterSet):

def all_titles(self, queryset, name, value):
    return MsTune.objects.filter(
        Q(name__icontains=value) | Q(title__icontains=value) | Q(alt_title__icontains=value)
    )

def ind_1(self, queryset, name, value):
    return MsTune.objects.filter(
        Q(index_standard_1__startswith=value) | Q(index_gore_1__startswith=value) | Q(alt_index_gore_1__startswith=value) | Q(alt_index_standard_1__startswith=value)
    )

title = django_filters.CharFilter(method='all_titles', label="All title fields")
index_standard_1 = django_filters.CharFilter(method='ind_1', label="Index 1")

class Meta:
    model = MsTune
    fields = ['index_standard_1', 'title', ....]

It all works well when I'm making queries which do not involve both 'title' and 'index_standard_1'. Nevertheless, if I'm searching for something with a specific title AND with a specific index, either the index search or the title is ignored, i.e. the query returns all the indexes or all the titles, ignoring a parameter of my search. What am I overlooking?

willeM_ Van Onsem · Accepted Answer · 2021-01-15 21:25:45Z

4

You need to filter the queryset, not make two querysets from the model, so:

def all_titles(self, queryset, name, value):
    return queryset.filter(
        Q(name__icontains=value) | Q(title__icontains=value) | Q(alt_title__icontains=value)
    )

def ind_1(self, queryset, name, value):
    return queryset.filter(
        Q(index_standard_1__startswith=value) | Q(index_gore_1__startswith=value) | Q(alt_index_gore_1__startswith=value) | Q(alt_index_standard_1__startswith=value)
    )

answered Jan 15, 2021 at 21:25

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

HBMCS Over a year ago

Of course! Thank you so much, it now works like a charm. I need to wait 6 hours for accepting your answer.

Collectives™ on Stack Overflow

Queries on multiple fields, each with a custom method, with django-filter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related