I am just trying to add a filter where a foreign key of the table being queried is NULL with the UI (non-SQL).
Table1
id
name
table2_id
Table2
id
name
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”
This should work fine. You would select Table1 when you start a new question, then add a filter. In the filter picker you should click on the name for Table2 to expand its columns, then click on Table2.id and choose the not empty filter option and apply the filter.
Right, that’s what I did, but I end up with a “There was a problem with your question…
java.lang.NullPointerException” error. I do use GUIDs so that may or may not be why It’s hitting the NullPointerException? Happens for both “empty” or “not empty.”