Multiple-select form and query django

Question

One of my fields in my model has a choice field:

STATUS = Choices(
   ('first', _('car')),
   ('second', _('motorcycle')),
   ('third', _('bicycle')),
)

My filter function looks like this:

choice = request.GET.get('choice')

vehicles = vehicles.filter(status=choice).order_by('-date_posted')

The filter works, when I select only one choice, but when I am trying to select more than one choice it only catches the last one selected.

The query looks like that:

?choice=first&choice=second

Any idea how to make it, so it would display items, based on more than one choice?

willeM_ Van Onsem · Accepted Answer · 2020-12-31 22:46:23Z

2

You can use .getlist(…) [Django-doc] to obtain the list of options, and then use the __in lookup [Django-doc] to retrieve the vehicles where the status is one of the elements in the list:

choices = request.GET.getlist('choice')

vehicles = vehicles.filter(status__in=choices).order_by('-date_posted')

answered Dec 31, 2020 at 22:46

willeM_ Van Onsem

482k33 gold badges483 silver badges624 bronze badges

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

1 Answer 1