The letter case of column alias names in RSA Identity Governance and Lifecycle tabular reports is not retained
Originally Published: 2019-08-20
Last Modified: 2023-11-30
Article Number
000041199
Applies To
RSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
 
Issue
When column alias names are used in RSA Identity Governance & Lifecycle tabular reports, the letter case of the column alias name is modified when the report is saved.

For example:
  1. Login to the RSA Identity Governance & Lifecycle user interface and click on Reports > Tabular.
  2. Use the "Create Report " button to generate a new report.
  3. Add a report name under the General Tab.
  4. Add a SQL query under the Query tab to show data in the report. Make sure the query uses alias names for column headers.
  5. Below is an example where the alias column name is DEPARTMENT.
User-added image
  1. Go to the "Display Attributes" Tab and make sure the letter case of the alias name is as per your requirement. In this example the alias name is DEPARTMENT.
User-added image
  1. Then Click on "Preview" or the "Run Report" option to view the results. The column name should be DEPARTMENT but it has been modified to Department.
User-added image
Cause
This is a known defect reported in engineering ticket ACM-87390.
Resolution
This issue is resolved in the following RSA Identity Governance & Lifecycle patches:
  • RSA Identity Governance & Lifecycle 7.0.2 P15
  • RSA Identity Governance & Lifecycle 7.1.0 P08
  • RSA Identity Governance & Lifecycle 7.1.1 P02

Related Articles

Trending Articles

Don't see what you're looking for?