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

Unable to search values in report definiton's Available Values



Unable to search for any value in the report definition's 'Available Values'.

Error Messages

Not Applicable

Steps to Reproduce

  1. Create a report definition.
  2. Add a Filter condition.
  3. Click the 'Select Values' field.

Root Cause

This behavior is as per Pega product design.

The properties used as columns in the report definition, used the default control of the property. In this usecase, the pyStatusWork had the default control as 'WorkStatus' and the control code performed a lookup to the corresponding field value and its localized value. However, since the out-of-the-box status (such as, New, Open, or Resolved-Completed) already had the localized value defined in the Field Value rule, the same localized value displayed. Open-Intriage was a custom status (field value) which was created without the localized value in it.

<pega:when java='<%=!tools.getParamValue("ClassNameForLocalize").equals("")%>' > <pega:lookup className="Rule-Obj-FieldValue" property="pyLocalizedValue"> <pega:key name="pyClassName" value="<%=tools.getParamValue("ClassNameForLocalize")%>"/> <pega:key name="pyFieldName" value="pyStatusWork"/> <pega:key name="pyFieldValue" value="<%= tools.getActive().getStringValue() %>"/> </pega:lookup>

Since the lookup failed to obtain the localized value (since it was null in the Field Value rule), empty values displayed when the report definition  was executed.


Perform either of the   following local-changes:
  • Configure a localized value in the Field Value rule since the properties used in the report definition used the default control format of the property defined.
  • For pyStatusWork column in the report definition, click Settings and set 'Text Input' as the Column format.

Published 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