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.
Accepted Solution
Updated: 19 Apr 2022 4:26 EDT
Pegasystems Inc.
GB
@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.
Pegasystems Inc.
GB
@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.
HCL
IN
@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.
Accepted Solution
Updated: 19 Apr 2022 4:26 EDT
Pegasystems Inc.
GB
@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.
HCL
IN
@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.