Unexposed properties cannot be selected in classes mapped to external tables
Hi Team,
I have seen this/similar issue in PDN with different work arounds. Is the error valid ? It generates the class fine and test connectivity also works.When I create a RD in the class and use one of the 3 columns in "Edit Columns" under Query tab,I get the error "Unexposed properties cannot be selected in classes mapped to external tables".
Can please some one explain why the error pops up ?
Cheers,
Prem
Message was edited by: Premjit Mishra
Accepted Solution
Pegasystems Inc.
US
This looks completely legit. If a column is unexposed and the table is external, we throw the error, likely due to the fact that there is no UDF defined in any external database.
Pegasystems Inc.
US
btw, this is not the right place to post this and you should try the pega support community first. This is a question in the area of Reporting not core engine per se.
Pegasystems
IN
Just to understand, did you have an external mapping in the class which was not working correctly and thus you had to create columns in lowercase? Also, which database is this?
Pegasystems Inc.
AU
Hi Rajiv,
I was using postgres 9.5. I could map the external class to the table correctly and it reflected the number of columns and rows correctly. When I tried to refer the property in a RD,I got the error. The column names in DB was in mixed case,so I changed to all lower case as all other schema from Pega was in lower cases as well. It worked!!. I don't know why though.
Cheers,
Prem
Pegasystems
IN
Thanks for the details Premjit. In the Pega platform, the generated DDL or DML doesn't use quoted column names and are thus referenced in the default case of the database (lowercase for PostgreSQL, uppercase for Oracle and DB2 and mixed case for SQL Server). Thus changing it to lowercase for your PostgreSQL DB did the trick for you.