How to dynamically assign multiple reviewers in a review
3 years ago
Originally Published: 2015-03-18
Article Number
000047124
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.9
Platform: Linux
Platform (Other): null
O/S Version: Suse Linux
Product Name: RSA-0018000
Product Description: Access Certification Manager
Issue
You may find yourself with a situation where you cannot determine who the reviewers should be ahead of but you have certain business logic to figure it out at review time.  A coverage file can be used to modify the reviewers that are assigned to your reviews.  The question is, how to use it to assign multiple reviewers without manually editing the coverage file.
Resolution
There are a few methods that you can use to accomplish this:

1. Write a program/script using your business logic and have it write the entire coverage file on the fly.

2. Use a bitmap for the filter field of the coverage file.  This can work well if you have a short list of reviews to assign to any particular reviewer.  If there are too many, the bitmap could grow to a very large set of numbers.

3. The filter field of the coverage file can contain any valid Oracle SQL statements.  Therefore, it can contain a complex SQL statement that uses your business logic.