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

Elastic Search on External Table Only Returns 1 Result



Elastic search has been enabled on an external table. After indexing the class mapped to the external table and running pxRetrieveSearchData, only 1 result is returned. A normal report definition on the external class returns the correct number of results. Elastic search is not behaving correctly on external tables.

Error Messages

No error on screen. Incorrect amount of results are returned.

Steps to Reproduce

Step 1) Enable Elastic Search on external table
1.1) Create an external table
1.2) Map table to a PRPC class using the connection and metadata wizard
1.3) Navigate to the class create through the wizard and select the advanced tab. Modify the to have ruleform type of harness
1.4) create pySearchModel data transform in the same class and add the properties of the class that you want to be indexed
1.5) create simple report definition on class that retrieves the properties you added in pySearchModel
1.6) Run the reindexer through designStudio > System > Settings
1.5) reindex data classes
Step 2) Run activity pxRetrieveSearchData and enter the following values for the parameters:

Root Cause

A defect in Pegasystems’ code or rules.


Apply Hfix-24761


Published January 31, 2016 - 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