Hi,
I have a requirement to show dynamic values in dropdown in the request. Use case is to show disabled users in the dropdown who were reporting to the logged in user. Can someone please suggest how this can be achieved? Thanks in advance.
Hi,
I have a requirement to show dynamic values in dropdown in the request. Use case is to show disabled users in the dropdown who were reporting to the logged in user. Can someone please suggest how this can be achieved? Thanks in advance.
I suggest you take a look at the following post https://www.quest.com/community/products/one-identity/f/identity-manager/22297/complex-sql-in-request-properties?pi8709=1
The sample from Sven Früh-Klima (the screenshot) contains the usage of %UserUID% to reference to the logged in user.
Your query should look like the following.
IsInActive = 1 AND UID_Person IN (Select UID_Person FROM HelperHeadPerson where UID_PersonHead = '%useruid%')
Hints:
IsInActive = 1 AND UID_PersonHead = '%useruid%'
In addition, you will need to apply Hotfix VPR#29914 that should be available via support.
Thanks Markus for the help. I will get the hotfix from support.