SecurID® Governance & Lifecycle Knowledge Base
Find answers to your questions and identify resolutions for known issues with knowledge base articles written by SecurID Governance & Lifecycle experts.
Article Number
000035529
Applies To
RSA Product Set: Identity Governance and Lifecycle
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0.2 P02
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 7.0.2 P02
Issue
In 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.
Image description
It appears to save correctly after selecting the OK button:
Image description
But when you re-edit the review, the column name has been modified:
Image description
Image descriptionIt appears to save correctly after selecting the OK button:
Image descriptionImage descriptionWorkaround
Defect 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,
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%'
In this article
