Foreign key 'is empty' filter / inner join


#1

Hi,

I’m trying to set a filter that only selects rows where there is no foreign key relationship to another table. Specifying this as ‘myforeignkey is empty’, just as I can do for regular fields, would seem ideal but I can’t.

In SQL this would translate to an INNER JOIN. Am I missing something here?

Thanks.