Passing isblank() in SQL Security Filter

[PCV_Tech]

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?

[WillowMobileSys · Accepted solution]

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.