How can I add OR conditions in Django filters but with conditions

Question

So let's say I have a interface that has a filters section (not django filters but just normal filters that we see on product listings etc).

Now what I want is that: If Individual is checked, then only show Individual which is very easy.

But things get messy when you choose two, let's say individuals and couples. Then I would need alot of if statements for this and changing the filters accordingly.

I'm doing this currently like this:

if individual and not couple and family:
                query = query.filter(Q(partner="individual") | Q(partner="family"))

            if individual and couple and not family:
                query = query.filter(Q(partner="individual") | Q(partner="couple"))

            if not individual and couple and family:
                query = query.filter(Q(partner="family") | Q(partner="couple"))

            if individual and not couple and not family:
                query = query.filter(partner="individual")

            if not individual and couple and not family:
                query = query.filter(partner="couple")

            if not individual and not couple and family:
                query = query.filter(partner="family")

which is very messy.

Basically I need something like this (PHP Code).

$sql = "SELECT * FROM abc WHERE";
if($individual){
   $sql .= " partner=individual"; 
}
if($couple){
   $sql .= " OR partner=couple"; 
}
if($family){
   $sql .= " OR partner=family"; 
}
$sql .= " order by id desc";

now I know the php part above is not correct, it will through error if $individual is false because then there would not be any condition after WHERE and directly OR. But it's just to give you an idea.

Thanks!

Answer 1

You could create a list of activated options and use __in lookup, like so:

my_list=(opt1, opt3)
query_filtered=query.filter(partner__in=my_list)