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

NULL values for data table properties with external mapping



The application consists of a class that has two properties with external mapping.
When opening the class instances through the Edit data instances option on the data tables landing page, values in the properties do not display. The actual data displays only when editing individual records.

Error Messages

Not Applicable

Steps to Reproduce

  1. Create a class and configure external mapping for the table used.
  2. Populate the Records. Verify if they exist in the database table.
  3. Create a List and DataTableClassEditor List View for this class.
  4. Navigate to Data Model > Data Tables. The class is listed with two icons.
  5. Click the Gear icon in the Internet Explorer browser. In the new window, the data displays with the values missing for the exposed properties.
  6. Click the Magnifying glass icon for any row. The data is present.
  7. Click the Edit in Excel button. The values display in Excel.

Root Cause

A defect in Pegasystems’ code or rules.
The Obj-List Where and Order by clauses used the property name instead of external mapping (for column names) in query generation.


Apply HFix-47044.


Published November 29, 2018 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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