Question

5
Replies
541
Views
Leshan Chathuranga (Leshan_C)
Virtusa
Associate Consultant
Virtusa
LK
Leshan_C Member since 2014 3 posts
Virtusa
Posted: January 26, 2017
Last activity: February 15, 2017
Posted: 26 Jan 2017 7:12 EST
Last activity: 15 Feb 2017 4:14 EST
Closed

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

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.