Support Article

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

SA-63014

Summary



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.



Resolution



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.

Published August 13, 2018 — Updated March 27, 2019

Have a question? Get answers now.

Visit the Pega Support Community to ask questions, engage in discussions, and help others.