Support Article
Sorting doesn't work in grid with pagelist as source
SA-37845
Summary
User has configured a repeating grid with the source as embedded pagelist and enabled "Allow sorting on columns" in the grid operations tab, also column level sorting is enabled.
The pagelist that is specified in the source of repeating grid has data access configuration as "Refer to Data Page".
While processing the flow, when user tries to sort on the columns, it does not get sorted.
Error Messages
No error message on the screen but the sorting on columns does not happen.
Steps to Reproduce
1. Process the flow to the point that contains the repeating grid.
2. Click on the column headers to sort.
3. Observe that the sorting doesn't happen.
Root Cause
This is an expected behavior and works as per design when the data access for the pagelist property is given as "Refer to data page" as the data will not get sorted in the clipboard when data access is "Refer to data page".
Resolution
If the data has to be sorted on the clipboard and get that reflected on the UI, use "Copy to data page" as the data access for pagelist property that acts as a source for the repeating grid.
Published June 1, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.