Tried with the solution provided in the above article but didn't resolved an issue.
We have configured a parameterized data page as a source to a table, data page is of read only with scope thread. While sorting the data page is reloading again and sorted data is updated with new results/records which is causing an issue. Please provide the alternate approaches for this.
@[email protected] the support article SA-24879 which I referenced in my response to you informs you of your options, as it states:
A row refresh causes the data to be retrieved from the data page which is a new interaction and causes the data to refresh.
If it is a requirement to use a data page with refresh per interaction strategy as the source for a grid then this behavior should be considered as part of the design.
Solution 1: Update the refresh strategy of the data page to use the "Reload if older than" and "Do not reload when" settings.
Solution 2: Disable grid sorting.
Solution 3: Using static data for the grid. For example source the data from a property that is copied from the data page.
Therefore please either avoid the Refresh, or avoid the sorting in the options provided above.