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

Report filter does not work when text is added for a search



Report filter allows selection of Available and Valid values.

Error Messages

Malformed SQL , Missing Where Clause causes, SQLException.

Steps to Reproduce

  1. Open the Pega report definition.
  2. Run the report and select any filter criteria. A modal dialog must open.
  3. Add text in the Available Values's Search.
  4. Click the Search icon.

Root Cause

A software use or operation error.
The external database used for the Search did not have the pxObjClass column.


Here’s the explanation for the reported behavior:

This functionality works for Pega Internal tables which have the pxObjClass column in them, else the SQL is malformed.

Perform the following local- change:
  1. Add the pxObjClass to the external table.
  2. Populate the value in the table.
Suggest Edit

Published March 27, 2019 - 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