Support Article
Report definition filtering displays results of first page only
SA-61001
Summary
In a report definition, when filtering cases based on any field, only the results of the first page displays. That is, filter is applied on the first page only.
Error Messages
Not Applicable
Steps to Reproduce
Perform filtering on list view results. All the column values do not display while providing the coulmn values for filtering.
Root Cause
This behavior is as per Pega product design.
The list view fetches the data pagewise. Each page's data is added to pyLookUpList. Hence, while filtering the column, only those column values which are present in the pyLookUpList page, display.
For example,
Consider a total of 50 records and a page contains 10 records.
There are 5 pages. Each page has 10 records.
When the first page is displayed, the list view fetches only the first page's data and adds it to pyLookUpList. Clicking the column filter condition displays only values which are present on the page.
Resolution
Perform the following local-change:
- Modify list view to report definition.
- Source the report definition to a repeating grid.
- Use pagination to limit the number of records which must be displayed per page, on the repeating grid.
- Enable filtering on the column.
Published August 24, 2018 - 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.