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

Manager is not picking while update the user form

Sekhar
New Contributor III
New Contributor III

Hi,

In the dynamic attribute for manager value client is asking to displayname in the drop down, so we have modified the value in the dynamic attribute in the manager. 

Updated Query:

select distinct username as ID, u.displayname as inlinedescription from users u left join accounts on systemUsername = name where statuskey=1 and (status=1 or status="Manually Provisioned")

While updating the user the manager value is not picking.

Sekhar_0-1689147701252.png

 

Original Query:

select distinct username as ID, systemUsername as inlinedescription from users left join accounts on systemUsername = name where statuskey=1 and (status=1 or status="Manually Provisioned")

If we use original query, its picking the manager value while updating user in the user request form.

Sekhar_1-1689147808378.png

 

Can you please help me in this issue.

 

3 REPLIES 3

naveenss
All-Star
All-Star

Hi @Sekhar ,

Can you try with the below query?

select distinct users.username as ID, users.displayname as inlinedescription from users left join accounts on systemUsername = name where statuskey=1 and (status=1 or status="Manually Provisioned")
Regards,
Naveen Sakleshpur
If this reply answered your question, please click the Accept As Solution button to help future users who may have a similar problem.

pmahalle
All-Star
All-Star

Hi @Sekhar ,

Any specific reason you are joining accounts table here?

Here you want to show manager of user which is selected for update showing in Unique ID field, is that the correct understanding? If yes, share attribute name of Unique ID.


Pandharinath Mahalle(Paddy)
If this reply answered your question, please Accept As Solution to help other who may have a same problem. Give Kudos 🙂

Sekhar
New Contributor III
New Contributor III

Hi @naveenss ,

The query is picking now the manager values.

Thank you for quick response.