Am I crazy? Probably.
I am just trying to add a filter where a foreign key of the table being queried is NULL with the UI (non-SQL).
In SQL form it would be:
SELECT * FROM table1 where table2_id IS NULL;
I can’t seem to do it because the FKs get hidden from Table1’s filterable fields and adding a check for empty on Table2’s id field returns the error “java.lang.NullPointerException”
Am I missing some very obvious method to do it?
Thanks! And please shame me if I missed it.