Need to restrict OTBI report prompt values based on the user logging in

Sharmava

I am creating an OTBI report. Need to implement the security restriction.

The prompt values should be displayed based on the user who is logged in. Please help.

Currently, the query used for prompt is:

SELECT "Position"."PER_POSITIONS_DFF_B_N_2DN_RG_STRCTR_" FROM "Workforce Management - Worker Assignment Real Time" FETCH FIRST 65001 ROWS ONLY

Bhaskar Konar

Hi @Sharmava,

Please use the following SQL which will make sure the security in place.

SELECT "Position"."PER_POSITIONS_DFF_B_N_2DN_RG_STRCTR_" FROM "Workforce Management - Worker Assignment Real Time" WHERE "Worker"."User Name" =  VALUEOF(NQ_SESSION."USER")

Hope this help.

Cheers,

Sharmava

Thankyou Bhaskar.

Please let me know what should be used if prompt values should be displayed based on the role of the user who is logged in.