Cannot Expose Base Property
In Pega 7.1.7 with PCS for Healthcare 7.1.3, a property shows as exposed in the database, but it is throwing guardrail warnings that indicate the column is not exposed.
These properties are not optimized: .CAParentID. Displaying them may result in poor performance. Consult your system administrator about optimizing properties for reporting.
Steps to Reproduce
Report on CAParentID in the implementation layer of a CPM instance.
The issue is related to the SQL Server case sensitivity on “CAParentID” vs. “CAPARENTID”.
Perform the following two local-changes:
1. Alter the column name to CAParentID
2. Switch the collation as case insensitive in MS-SQL database. (SQL server determines case sensitivity by COLLATION)