Support Article
Filter Condition in Report Definition OOTB not working
SA-40339
Summary
Out-of-the-box filters in a report definition do not display records during bulk processing, in the Manager portal.
Error Messages
Not Applicable
Steps to Reproduce
- Launch the Manager portal
- From the Operator menu, navigate to Bulk Actions > Select Process radio button
- Filter properties (such as, Case Type, Assigned To Operator, and Work Status) are displayed with the results
- Delete the Work status property row and click the Filter Cases button
- Remove and add the same filter value for the Assigned To Operator property
- Click the Filter Cases button
Root Cause
Records are not retrieved from the database and incorrect SQL query is generated when a new property is included in bulk processing, causing the filter property autocomplete to refresh the section and call the activity pzDefaultOperators. This activity sets pyUserIdentifier and pyLabel, used to retrieve records from the database, to "".
Resolution
Apply HFix-35324
Published September 11, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.