Support Article

Unable to search values in report definiton's Available Values

SA-97793

Summary

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

Error Messages

Not Applicable

Steps to Reproduce

Create a report definition.
Add a Filter condition.
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.

Resolution

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.