000035529 - Review SQL SELECT in the Content tab is not working in RSA Identity Governance and Lifecycle

Document created by RSA Customer Support Employee on Sep 19, 2017Last modified by RSA Customer Support Employee on Sep 19, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000035529
Applies ToRSA Product Set: Identity Governance and Lifecycle
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0.2 P02
IssueIn the Review Definition Contents tab there is the ability to add a WHERE clause under Include application entitlements. When a sub-select is used (without table aliasing) using a column name with an underscore, that column name gets converted to camel case. It appears to work at first but after returning to edit the review, column_name becomes columnName.
 
User-added image

It appears to save correctly after selecting the OK button:
User-added image

But when you re-edit the review, the column name has been modified:
User-added image
WorkaroundDefect ACM-78739 has been created for this issue.
Use an alias in the SQL SELECT for the table or view and then it will parse correctly without modifying the column name in the sub-select.
For example, if the SQL statement is as follows, 

SELECT id FROM PV_APPLICATION_ENTITLEMENT WHERE alt_name LIKE '%Manage%'

Change to the example below:

SELECT ae.id FROM PV_APPLICATION_ENTITLEMENT ae WHERE ae.alt_name LIKE '%Manage%'

 

Attachments

    Outcomes