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

User onboarding approval flow

Shubhamjain27
New Contributor
New Contributor

Hi Everyone,

We have a requirement to use user form to create users and add a dynamic attribute to map manager username to the user Owner.

Now if we want to create a workflow, what would be the customquery if the request needs to go to manager mentioned in the form.

If we have a secondary manager in the form and we need a workflow where if the secondary manager is assgined, the approval should go to secondary manager. What to add in the workflow's if else statement to get it working?

Any answers would be appreciated

1 REPLY 1

rushikeshvartak
All-Star
All-Star
  • Sample if else conditions 
    • ((dynamicAttributes.get('customproperty61') != null) and (dynamicAttributes.get('customproperty61') == 'Leaver')))
      • customproperty61 will be users column from dynamic attribute.
  • Custom Query 
  • select u.userkey from users u where lower(u.userkey) in (select lower(raa.ATTRIBUTE_VALUE) from request_access_attrs raa , ars_requests ar, request_access ra WHERE ar.REQUESTKEY = ra.REQUESTKEY and ra.REQUEST_ACCESSKEY = raa.REQUEST_ACCESS_KEY and ar.REQUESTKEY=${ARSREQUEST.id} and raa.ATTRIBUTE_NAME='secondaryManager')

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