Hello,
We have a requirement to populate a dynamic attribute with the user's account status during the emergency access roles using the "SQL ENUM" dynamic attribute. The dynamic attributes are created under the endpoint DA as part the "Role" request type.
SQL Query used: select case when a.status=1 then 'Account is Active' when a.status in ('Inactive','2','Manually Suspended') then 'Account is Inactive' end as id from accounts a,user_accounts ua,endpoints ed,users u where a.accountkey=ua.accountkey and ua.userkey=u.userkey and a.endpointkey=ed.endpointkey and ed.endpointname='ABC' and u.userkey=${requestee}
I have used the below variations of the binding variables to fetch the requestee details and none of them are working.
${requestee} - not working
${requestee.id} - not working
${users.id} - not working
${id} - not working
${requestedFor} - not working
${userkey} - not working
${REQUESTEE} - not working
${users.userkey} - not working
Emergency Access roles are requested to the end-users from ARS > Request Emergency Access Roles > Select the user from the user list > Choose the emergency access roles > Dynamic attribute should be populated here before the user submits the request.
Has anyone come up with a similar requirement? Any leads on this would be highly appreciated.
