and more in a single search tool across platforms. Read the announcement here. |
03/13/2023 11:08 AM
Hi,
We have a requirement like pulling the username from a custom property of entitlement.
Suppose entitlement custom property30 is cn=xyz,dc=abc,....
Then for approval the workflow should be triggered to xyz.
Appreciate any suggestion regarding how to link entitlement value with users table.
Regards,
Soumya
Solved! Go to Solution.
03/13/2023 04:39 PM
You can use custom assignment block to define your logic
Example: (Assuming xyz is the username)
select userkey from users where username =(select SUBSTRING_INDEX(SUBSTRING_INDEX(customproperty30, ",", 1), "=", -1) from entitlement_values where entitlement_valuekey=${REQUESTACCESSOBJ.id})
03/15/2023 10:11 AM
Thank you. It worked.
Regards,
Soumya