Sorting issue in a Table with data page as a source.

Hi All,

We are showing a list of assigned cases on a portal. Configured read only data page as a source with thread as a scope and set refresh once per interaction under load management.

While sorting the list of assigned cases, the cases got sorted on the UI but not in the clipboard. When I try to open the sorted case, the case with out sorting gets displayed.

Ex: Before sorting the table contains cases as listed below.

X, Y, Z, P, Q, R

After sorting the table contains the cases as below.

Z, P, Q, X, Y, R

After sorting when I click on Q case, the Z case is getting displayed.

The data page is getting refreshed while doing sort. I can’t remove the refresh once per interaction, as the table need frequent update with assigned cases. Kindly provide the solution for this.

Regards,

Hyma.

@HB@77 do you have pagination?

Please could you try solution 3 as explained in the following article?

If you require further help could you provide screenshots and details of the UI configuration?

The symptoms sound very similar to this forum post.

@MarijeSchillern Yes, we have pagination.

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.

Regards,

Hyma.

@HB@77 the support article SA-24879 which I referenced in my response to you informs you of your options, as it states:

Root Cause

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.

Solutions include:

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.

@MarijeSchillern Tried with the solution 3, copied data from data page to a list property and used as a source. It worked for me. Thank you Marije.

Regards,

Hyma.