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

Issue with Register User Form || Manager Approval

Manu269
All-Star
All-Star

Hello Team,

We are working on Register user form and we have an attribute called manager on the form.

  • Attribute Type: Single Select From SQL Query

  • Values: select username as ID, CONCAT_WS(', ',IFNULL(customproperty8,lastname),IFNULL(preferedFirstName,firstname)) as inlinedescription from users where username in (select distinct owner from users where owner is not null and statuskey=1);

  • We are using this manager which is selected on the form to trigger approval flow.
  • This works very well when we are creating the user.
  • The problem happens when we are trying to update the same user via update user request form.
  • We see that workflow is unable to resolve the manager for the same and assigning the same to admin.
  • Please note there is a possibility that manager may get modified during the update process.
  • We are using custom assignment block with the query : select userkey from users where userkey=${manager}
Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.
11 REPLIES 11

rushikeshvartak
All-Star
All-Star

select u.userkey from request_access_attrs raa, request_access ra, Users u where u.username = raa.ATTRIBUTE_VALUE and raa.REQUEST_ACCESS_KEY = ra.REQUEST_ACCESSKEY and ra.REQUEST_ACCESSKEY = ${REQUESTACCESS.id} and raa.attribute_name = 'manager'


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Manu269
All-Star
All-Star

It now got assigned to admin at creation stage only

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

I hope you updated dynamic attribute name in query


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Manu269
All-Star
All-Star

Yes, my DA name is manager

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Run query from data analyzer and validate. What is value whether its username or userkey accordingly update query 

 

select u.userkey from request_access_attrs raa, request_access ra, Users u where u.userkey = raa.ATTRIBUTE_VALUE and raa.REQUEST_ACCESS_KEY = ra.REQUEST_ACCESSKEY and ra.REQUEST_ACCESSKEY = ${REQUESTACCESS.id} and raa.attribute_name = 'manager'


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Manu269
All-Star
All-Star

I was able to fix the issue @rushikeshvartak .

We have to user userkey instead of userame.

Adding updated query :

select u.userkey from request_access_attrs raa, request_access ra, Users u where u.userkey= raa.ATTRIBUTE_VALUE and raa.REQUEST_ACCESS_KEY = ra.REQUEST_ACCESSKEY and ra.REQUEST_ACCESSKEY = ${REQUESTACCESS.id} and raa.attribute_name = 'manager'

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Good base query worked and you got way forward 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Manu269
All-Star
All-Star

@rushikeshvartak there is few more issue as we see.

In my form there are more than 7-8 attributes apart from manager which can be updated.

Now the probelm is when any other atrribute is modified apart from manager the request goes for admin approval.

Can you assist how to handle?

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

Use union and get values from users table when manager attributes not exists in request access table 


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

Manu269
All-Star
All-Star

any sample that can be referred?

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.

select u.userkey from request_access_attrs raa, request_access ra, Users u where u.userkey= raa.ATTRIBUTE_VALUE and raa.REQUEST_ACCESS_KEY = ra.REQUEST_ACCESSKEY and ra.REQUEST_ACCESSKEY = ${REQUESTACCESS.id} and raa.attribute_name = 'manager' union select userkey from users where userkey=${manager}


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.