Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Error when creating reports on external tables



User creates a report from the Case Manager portal on an external table, where they get the following error when using a class mapped to an external table.
.pyReportDefinition: ** Unexposed properties cannot be selected in classes mapped to external tables

However, Creating a report definition as a developer on this table works fine for the user.
Tomcat 7.0.55
PostgreSQL 9.1.14

Error Messages

.pyReportDefinition: ** Unexposed properties cannot be selected in classes mapped to external tables

Steps to Reproduce

1. Create a mapping to an external table
2. Create a report from the Case manager portal

Root Cause

As none of the properties in the class created was exposed, the mapping of the class with external tables could not be done.


The resolution suggested to customer was following local change :

The behavior can be overcome by editing the “pyDefaultReport” and “pyDefaultSummaryReport” in @baseclass

Steps to Do:
1)Go to App Explorer
2)Type @baseclass in App Explorer and click enter
3)In @baseclass go to ReportàReportDefinitionàpyDefaultReport
4)Delete all the columns from Edit Columns and Edit Filters
5)In edit Columns  only add a single row with property .pzInsKey and Select Save

After following the above mentioned steps, reports can be created from Case Manager Portal.

Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us