Passing isblank() in SQL Security Filter

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?

Solved Solved
0 1 78
1 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.  


View solution in original post

1 REPLY 1

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.  


Top Labels in this Space