Hi
How to use system session variable NQ_SESSION.ROLES inside a initblock with some case condition and store the result into a variable. This variable will be further used to hide presentation columns
The initblock query would be,
case when NQ_SESSION.ROLES like '%Admin%' then 0 end --> The output of the statement will be stored in a session variable
But am stuck at what will be the "from clause of this initblock query" keeping it dual doesn't work.
Thanks