Support Article

Performance issue on Grid Filters

SA-30560

Summary



Filters on Grid header taking long time to load unique values. Grid filter performance issue occurs when 1000+ records in grid.


Error Messages



No Error Message


Steps to Reproduce

  1. Create a Repeat Grid and configure it to load 1000+ unique records.
  2. Run the Repeat Grid and click on filter option of column having unique values.


Root Cause



A defect in Pegasystems’ code or rules : It is the browser behavior that it is not able to loop through the list of rows in the grid to fetch the results in the given time.

Resolution



Perform the following local-change:

1. Open the grid design time configuration and click on the dot of the column as shown in below screen print.



2. Open properties of the column as shown below



3. Change the filtering configuration option from "Auto" to "Range/Search" as shown below.



Select the value:

 

 

Published November 18, 2016 - Updated November 22, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.