Is there a way to include null values when filtering on relations ?

[jlefebvre1997]

At the moment, since filtering on relations act as a simplified left join, if the requested relation is null, the results are not included. I think it's not the right behaviour, since for example if I ask for cats filtering by toys.color=$not:$eq:red, I expect cats that do not have any toys to show up as well (but that's debatable ofc)

[Helveg]

Left joins should include null values 🤔 Inner joins don't. Can you see if adding a 2nd filter with toys.color=$or:$null gets you the correct results?