query by OR filter

[LeoWelter]

I've build a page with django-filter, works beautiful with multiple checkboxes for failed/passed tests.
If I select multiple checkboxes, django-filter does a combined lookup as expected, i.e. the product passes QC, but fails on customer payment, and another bunch of checks

What is the best approach to build an OR version, so the filter will return not only those records that match all parameters, but those records that match any of the given parameters.
my approach would be to add a checkbox to the form for and AND or an OR query and then write some code: but where would be the best place to put that code?

[realsuayip]

You basically have to override filter_queryset to write that kind of custom stuff. You could probably also use the pattern described here:

#1020

At the end of the day though, you might end up needing to create arbitrary Q objects, in that case I would recommend checking out the library I mentioned in the issue above. It also natively supports changing query connector (AND, OR) based on user input.