Hi ther guys,


I have a dashboard with two parameters and a select (I have a bit more but the problem is here).
Here is my sqlJndi query:

SELECT
ID, NAME
FROM
table1
INNER JOIN table2 ON tabl1.ID=table2.ID
WHERE
table1.ID = 7
AND table1.PERMISSION BETWEEN 20 AND (CASE ${userRole}
WHEN '80' THEN 80
WHEN '60' THEN 60
WHEN '40' THEN 40
WHEN '20' THEN 20
END)

ORDER BY
table1.ID,
table1.POS


What I want to achieve, is when I set userRole to a value (80, or someone else), I get the values of the query in other parameter like param1 or whatever.

I've tried it with Parameters in the sqlJndi component ({userRole, userRole},{param1, param1}), but param1 is always empty, so my select component too.


I hope you can help me.

Thanks.