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! Go to 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.
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.
User | Count |
---|---|
17 | |
11 | |
5 | |
5 | |
5 |