Unable to fetch department name of user in dynamic attribute

[SwagatDas13]

Hi All,

We have added a dynamic attribute in endpoint level and we are trying to fetch Department name of user we choose in ARS form. Currently we are only getting success using below query :

select DEPARTMENTNAME as ID from Users where userkey = ${requestor}

which is fetching requestors Department name but we need requested user's Department name. Please let us know what variable we can use for requested user's Department name.

[SwagatDas13 · Accepted solution]

No worries, I have fixed using below query :

select DEPARTMENTNAME as ID from Users u where u.userkey=${user.id}