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

4 years ago

Originally Published: 2017-09-08

Article Number

000041526

Applies To

RSA Product Set: Identity Governance and Lifecycle
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.

It appears to save correctly after selecting the OK button:

But when you re-edit the review, the column name has been modified:

Workaround

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,

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%'

Don't see what you're looking for?

Related Articles

Trending Articles