Django-Filter: Search within an ArrayField with an Array?

Question

I have an all_positions datapoint that uses an arrayField. So some example data looks like:

all_positions: ["C", "1B"],
all_positions: ["RP", "CP"],
all_positions: ["CP"],

I'd like to be able to make a request similar to /api/player-profiles/?all_positions=RP,CP and return the second and third examples. Essentially, I want to return all players that have ANY of the positions passed into the URL in their all_positions data.

I've read about overlap, but not sure how I would integrate that into my django-rest filters. Here is what the filter currently looks like:

class PlayerProfileFilter(django_filters.FilterSet):
    all_positions = CharInFilter(field_name='all_positions', lookup_expr='contains')

Have you changed lookup_expr='contains' to lookup_expr='overlap' — Ahtisham
– Ahtisham, Commented Jan 28, 2022 at 2:11

Ahtisham · Accepted Answer · 2022-01-29 03:06:38Z

2

Just change the lookup filter in lookup_expr from contains to overlap:

class PlayerProfileFilter(django_filters.FilterSet):
       all_positions = CharInFilter(field_name='all_positions', lookup_expr='overlap')

answered Jan 29, 2022 at 3:06

Ahtisham

10.3k6 gold badges49 silver badges62 bronze badges

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

Collectives™ on Stack Overflow

Django-Filter: Search within an ArrayField with an Array?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related