Question
Unitedhealth Group
US
Last activity: 20 Mar 2019 20:14 EDT
Is there a limit on a report filter result values
Hi All,
I would like to know if there is a max limit on the number of values a filter can show when filtering report results?
***Edited by Moderator Marissa to update platform capability tags****
Pegasystems Inc.
US
I'm not sure if there is a hard limit. But if you are finding yourself in a situation where you have a very large number of unique values, you may want to consider using a search filter instead. Scrolling through hundreds of checkboxes is going to be unwieldy as far as UX is concerned, but you may also face performance issues as well which would exacerbate the issue.
Pegasystems Inc.
US
The limit of records is hard-coded as "10000" for Filters. You can check activity pzGetGridColUniqueValues in Pega-UIEnigne, java step 3.
/* BUG-159724: Based on discussion, setting max records fetched for unique value calculation to 10000. */
pyReportParamPageName.getProperty("pyMaxRecords ").setValue("10000"); //TODO: determine what is the maximum number of records that can be displayed in unique values grid.
pyReportParamPageName.getProperty("pyListFieldsGetMode").setValue("onlylisted");
pyReportParamPageName.getProperty("pyFilterSettings").getProperty("pyGetDistinctRows").setValue("true");
As Rett has mentioned that you will face performance issues when you are in a situation where you have a very large number of unique values.
You can enable pagination or use search filter instead.