Question
Displaying count of filtered fields for a Data Page Grid (sourced with Report Definition)
hello,
we have a requirement to display the count of all visible rows for the "My Work Items" on top of the table.
This count should be updated based on the filters applied by the user...
This is how the table looks in the DEV studio
As you can see it's sourced from a Data Page (List) that is using a Report Definition...
I tried the methods that were mentioned in previous forms (ex. creating a value label property and pasting this <%=(tools.getParamValue("totalRecords"))%>) however that didn't work for this particular case... I've also tried adding (<pega:reference name='param.totalRecords'/>) to the label but with no luck either
I see I could add a Header/Footer section to the table.. I was wondering how to customize one of those to display the count of the rows... your help would be appreciated
Healthfirst
US
Enable Header, add two columns one for Label and another one for value.
Southern California Edison Company
US
Thanks for the reply. Which Property did you use to display the Count?
It gave me an error when I added .TotalResutCount
Healthfirst
US
add the property with page. <pagename.Property>. make sure you have the page name in pages and classes tab
Southern California Edison Company
US
I tried but no luck...
I added the class where the Data Page is (ORG-TD-APP-WORK) to the Pages and Classes tab, however after saving it displayed error
ORG-TD-APP-Work does not exist or is not a valid entry for this ruleset and its prerequisites
I've also added the class where .pxTotalResultCount property resides (CODE-PEGA-LIST) however that didn't work either (It just displayed blank)
Healthfirst
US
if possible share pxTotalResultCount data clipboard view and section page and class view screen print.
Southern California Edison Company
US
would that suffice?
Healthfirst
US
step 1 : In section pages and classes tab add page: D_MyProjects , class: Code-Pega-List
step 2: In section configure property value : D_MyProjects.pxResultCount
It should work now
Southern California Edison Company
US
well that showed a number however it wasn't correct. The total number of records that I have is 16 and after filtering I have 14.. however it showed only 1
(screenshot below after applying filters)
Pegasystems Inc.
CA
Hi,
You seem to be using a datapage as a grid source. In that case, I don't think, pxTotalResultCount exists in clipboard for that specific datapage.
Param "TotalRecords" should make more sense in this case. I just tried using a label control with this <pega:reference name='param.totalRecords'/> in header/footer and it works fine when I filter the data in Table/Grid.
Configuration:
How it looks like
You can add this label in header/footer. And there's absolutely no need to add anything in pages and classes in this case. Let me know if this helps.
Southern California Edison Company
US
thx but I tried that initially (as well as <%=(tools.getParamValue("totalRecords"))%>)) but it didn't show anything.. even when I looked in the clipboard there was no totalRecords value