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