000037851 - The letter case of column alias names in RSA Identity Governance and Lifecycle tabular reports is not retained

Document created by RSA Customer Support Employee on Aug 23, 2019Last modified by RSA Customer Support Employee on Aug 23, 2019
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000037851
Applies ToRSA Product Set: Identity Governance & Lifecycle
RSA Version/Condition: 7.0.2, 7.1.0, 7.1.1
IssueWhen 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
CauseThis is a known defect reported in engineering ticket ACM-87390.
ResolutionThis 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