I am working on creating various views and due to data confidentiality I need to restrict the user to only be able to select certain values from the filter panel (e.

Hi all,

I am working on creating various views and due to data confidentiality I need to restrict the user to only be able to select certain values from the filter panel (e.g values: 1,2,3,4,5 - only 3 & 4 should be available to end user). Alternatively I created a List box-control with only values 3 & 4, which stores the selection ("3", "4" or "3,4") as a string list. (Prefer this option as I can use the string list to auto populate headers, titles etc.) I tried to feed this String into a view by means of the "Limit data using expression" functionality. This works but only if end user selects either 3 or 4, not when selecting both. A workaround using calculate column is possible, but for maintenance I would really prefer it to work by just using this expression function.

Any ways I can get get this to work? Thanks!

(2) Answers

Login