Since it doesnt look like isblank() converts to SQL ([column] IS NULL) is there a different way to use a security filter to pull rows with a specific column being Null that WILL convert to SQL?
First, analyze the column to determine if you can just make it required so that there is ALWAYS a value assigned. This eliminates the issue altogether.
If the column needs to be optionally chosen by the user then determine some value that represents null and assign it by default - basically convert it to column that is ALWAYS assigned but the default represents “not user assigned”. This will give you a physical value you can then use in the Security Filter to take advantage of database-side filtering.
1 Like