Entitlement customproperty to users table mapping in Workflow

[Soumyaprateek]

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

[sk · Accepted solution]

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})

[Soumyaprateek]

Thank you. It worked.

Regards,

Soumya