Can we customize Repeating Grid filter using two Property values for a single column?
We are having a requirement to filter a Repeating Grid column. Repeating Grid source is a Report Definition and the results of the Report Definition is stored in a Data Page. There is a property called DaysToGo which will calculate using two Property values (ActionDate, CaseCalender – calculation is done using a Control rule). All these three Properties are included in the Report Definition so when it generating the results for grid DaysToGo Property get values without any issue. For the filtering Pega behavior is execute the same Report Definition only for the filtering column (ex: Report Definition SQL -> SELECT DISTINCT DAYSTOGO FROM…..). In DB there are no values for DAYSTOGO so it shows blank for filters. Is there any way to customize repeating grid filters to solve this issue? PRPC V7.2
Pegasystems Inc.
IN
Hello,
I don't think we can customize the grid filtering. In the description you have mention DaysToGo is calculated on basis of 2 other properties. Is it using any custom control ?
Do let us know your thoughts/observations.
Best Regards,
Mounika
Pegasystems Inc.
IN
For non-auto control, grid filtering will not work. You can try this:
For that column, select Filtering Type as Range/Search, FilterBy as format and in the Filter by range field enter any field which is present tn DB (say.. any of the properties used to calculate DaysToGo field )
ScreenShot:
Other than this, I cannot find any option to perform filtering on the non-auto field.
Hope this helps.
Best Regards,
Mounika
Virtusa
LK