Andrew Byberg (NascoMan)
System Engineer
NascoMan Member since 2015 3 posts
Posted: May 29, 2018
Last activity: October 17, 2018
Posted: 29 May 2018 17:17 EDT
Last activity: 17 Oct 2018 8:20 EDT

Summarize Repeating Grid with Filters Applied

We have a requirement to display summaries of columns in a repeating grid layout. We are displaying rows that have been returned by a SOAP service. When filters are applied on the columns, we want the summaries to be updated. It seems there is not a very straightforward way to do this, because the application of filters does not alter the data page we are displaying.

What I have found is that we can use the activity pyPostGridUpdate (param.gridAction = “FILTER”) to "catch" a grid filter update and execute an activity. However, to calculate the summaries of the columns we have to re-apply the filters programmatically, because there is no option to loop through only the filtered results displayed on the UI.

So, my question: is there a way to loop through only the rows displayed on the repeat grid after a filter has been applied? I want to make sure this is not possible, before I try to recalculate the result based on selected filters by extracting the selected filters from pyFilterCriteria and then loop through my pxResults page to find matches and summarize. That solution seems awfully cumbersome.

***Edited by Moderator to update categories***

Low-Code App Development User Experience
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.