Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

dynamic Attribute - manager value.

Rajatlm10
New Contributor III
New Contributor III

I have a dynamic attribute which should show user's manager. 

 

I am trying to get the value populated using the query. 

select users.manager from users where username='${users.username}'

or 

${users.manager}.

 

but i am not able to get the value of manager in the field. 

Has anyone worked on the same before ?

1 REPLY 1

Raghu
Valued Contributor III
Valued Contributor III

try like below

update user page or exiting manager will get this query : select u.owner as ID from users u where u.userkey= ${requestee}

if Create User page user below:

DynamicAttr1: Single select from sql: SELECT distinct owner as ID from USERS where statuskey=1

user column mapping : owner


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.