Reset sorting and filter on a repeat Grid using Data page as source
I have a requirement on repeat grid. Now user has sorted on one of columns. the requirement is that we provide a button which when clicked should reset the sorting and filters applied. Does any one know how this can be acheived. I tried refresh section but the grid retains sorting and filtering.
***Moderator Edit: Vidyaranjan | Updated Categories***
Techmahindra
IN
Hi Pavan,
Please refer this article : https://collaborate.pega.com/question/72-refresh-section-works-report-sourced-repeat-grid-doesnt-work-data-page-sourced-repeat
Also confirm if you can use a report definition instead of data page to do the same?
Regards,
Shanthini Charles
Asurion
US
Hi Shanthini_Charles- I dont think the issue is same as the article you mentioned. These are the steps
1. When the section or repeat grid is loaded for the first time - the order of results that we see- lets call this as "default order"
2. Now user has sorted on (lets say) column 2 and later on he might sort on another column etc.
3. We have provided a button which when clicked should return back to default order.
Please let us know how we can reset all the sorting that user has applied.
Techmahindra
IN
Hello Pavan,
Have you tried the same with a report definition? Data page after sorting is not stored anywhere temporarily.
Regards,
Shanthini Charles
Asurion
US
Hi Shantini,
We are getting the data from a rest connector. Not sure if i can use report definition. However i found a work around. I use refresh list action on click of button and then use a pregridupdate activity to force grid action to SORT .
Techmahindra
IN
Hi Pavan,
Thanks for sharing your solution.
Regards,
Shanthini Charles
Blue Rose Technologies GmbH
DE
Hi,
Can you please check if checkbox to refresh the data page on every interaction is checked or not ?
Asurion
US
We dont want to refresh the DP on every interaction.