About
Example of dashboard prompt with a data level security.
The session variable can be row-wise initialized.
Articles Related
Parameters
Show
Logical SQL Result :
SELECT
Organisation."Organisation Team" saw_0
FROM
MY_SUBJECT_AREA
WHERE
(
(
Organisatie."Organisatie Team Centercode" = VALUEOF(NQ_SESSION."MY_TEAMS_CENTERCODE")
)
AND
(
VALUEOF(NQ_SESSION."GROUP") NOT IN ('Administrators')
)
)
OR
(
VALUEOF(NQ_SESSION."GROUP") IN ('Administrators')
)
ORDER BY
saw_0;
Default value
Logical SQL Result :
SELECT
ifnull(MIN(Organisation."Organisation Team"),'-') saw_0
FROM
MY_SUBJECT_AREA
WHERE
Organisation."Organisation Team Centercode" = VALUEOF(NQ_SESSION."MY_TEAMS_CENTERCODE")
ORDER BY
saw_0