Pooja Mehta

Looping in RSA IGL

Blog Post created by Pooja Mehta Employee on Jan 13, 2017

Feedback and suggestion are welcome.

This document is created for showing how to work on Loop in a workflow in RSA IGL. There are many requirements when we need to loop through the values in a workflow.

 

Steps

1) Create a Temporary Variable which will hold the data

2) Initialize the Temporary Variable

3) Read the data using SQL Node

4) Next Value - Feed the data Read from SQL Node into the Temporary variable

5) Take action If value exists/does not exist.

 

Example Shown Below :

In this example we need to Disable the Account. If there are any groups attached to the Account we will need to remove them.

 

1) Create a Temporary Variable which will hold the data

2) Initialize the Temporary Variable

   So, we have taken SQL Node and initialized the temporary variable

 Select '' as temp_groupname from dual

Here Temporary Variable is temp_groupname

3) Read the data into variable using SQL Node

 

(Select name as groupname from avuser.PV_USER_GROUP where id in
(Select group_id from avuser.PV_USER_GROUP_MEMBERSHIP where
user_id in (Select id from avuser.PV_USERS where user_id='${access_request_cri_meu_userId}'))
 and application_id in (Select id as apid from avuser.PV_DIRECTORY
 where name = 'Test') and name not like '%Domain Users%')

 

4) Next Value - Feed the data Read from SQL Node into the Temporary variable

Using Next Value Feed the Temporary variable with data read

 

 

6) Take  necessary action on condition If value exists/does not exist

Document Attached


Contributors:@Aaron Stromas, Pooja Mehta

 

Attachments

Outcomes