Sorting on table sourced from data page happening incorrectly
Hi,
We have a table in our application where sorting doesn't happen correctly.
If we sort by a particular column, another column in the table stays in the same order as it was before sorting. The column that is being sorted is a date time property and the column not sorting is a text property.
I've verified the values in the clipboard and, as intended, everything is being sorted correctly there. But it's not reflecting in the UI.
If we try to filter by a certain value, that value may not be correct.
I've tried removing columns and re-adding columns to the table. I've also tried recreating the table and I have the same result.
Has anyone run into something like this before? Any ideas for a solution?
***Edited by Moderator Marije to add Capability tags***
Pegasystems Inc.
GB
@KacieN62 please could you provide screenshots illustrating the issue?
Is your DateTime column being sourced by a pagelist as source, which in turn for the pagelist you refer to a data page? If so, then this is a expected behaviour where we suggest you to source the datapage instead of listproperty.
We need to understand the exact sources of the table (Report definition ? Does configuration involve a Data transform?
Could you please verify in data page reload per interaction is enabled or not?
Coforge
US
@MarijeSchillern Hi, and thanks for the reply. The data page is sourced from a report definition (Assign-WorkBasket) with a response data transform. The date time (ReferralDate) and text (SponsorName) properties are from the same joined class in the report (a class group), so the properties are embedded on each page. If I sort and view the clipboard, the values are correct, but the values for that SponsorName column do not sort in the UI. As you asked, I've attached some screenshots to show the results.
Thanks.
Pegasystems Inc.
GB
@KacieN62 apologies for the delay in response. I see that no other user has commented on your issue.
Regarding Pega sorting pages alphabetically - We are talking about “clipboard” utility here. The real data is stored in a BLOB column named “pzPVStream” in a compressed and encrypted format. “clipboard” utility is used to retrieve page data and present it to developer in a human legible way (using html/css underneath). The “clipboard” developer may have chosen to sort some pages or not to sort when prepare for the presentation. But the key is: The order you see in clipboard does not necessarily reflect the order in the BLOB.
For ordered elements, like the pages in a PageList, I believe it is always ordered in both Blob and clipboard presentation
Q: Is there a way to control the sorting order in the response when I use the model to create a response?
A:: Model in PRPC is very much like the constructors in C++/Java , it is used to initialize pages. You cannot use model to control how elements are ordered in Blob. Page data is stored in XML format. In fact, you cannot control the order of elements unless the elements are supposed to be ordered, for example, page list, or property list.
You cannot rely on the assumption that the pages/properties in the BLOB are sorted in some way. The only exception is page list and property list. You have to make your custom implementation to “sort” the response if you have to.”
@KacieN62 apologies for the delay in response. I see that no other user has commented on your issue.
Regarding Pega sorting pages alphabetically - We are talking about “clipboard” utility here. The real data is stored in a BLOB column named “pzPVStream” in a compressed and encrypted format. “clipboard” utility is used to retrieve page data and present it to developer in a human legible way (using html/css underneath). The “clipboard” developer may have chosen to sort some pages or not to sort when prepare for the presentation. But the key is: The order you see in clipboard does not necessarily reflect the order in the BLOB.
For ordered elements, like the pages in a PageList, I believe it is always ordered in both Blob and clipboard presentation
Q: Is there a way to control the sorting order in the response when I use the model to create a response?
A:: Model in PRPC is very much like the constructors in C++/Java , it is used to initialize pages. You cannot use model to control how elements are ordered in Blob. Page data is stored in XML format. In fact, you cannot control the order of elements unless the elements are supposed to be ordered, for example, page list, or property list.
You cannot rely on the assumption that the pages/properties in the BLOB are sorted in some way. The only exception is page list and property list. You have to make your custom implementation to “sort” the response if you have to.”
Did you log a support incident for this? If so we would be interested in helping track it and any solution that was found. Could you provide the INC id here?