Case Statement using VALUEOF(NQ_SESSION.ROLES) not working in dashboard prompt
I have a dashboard prompt 'Legal Employer'.
The oracle engineer told us that the subject area we are using is not a secured one i.e. even if a user's role is restricted for one legal employer, he will still be able to view all legal employers of the system in the dashboard prompt.
I want to restrict a user to view legal employers as defined in the role assigned to him. For example) User X has role that restricts him to view data for only legal employer Panagora. User X should only be able to see Panagora in the list of legal employers in the dashboard prompt.