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