Question

23
Views
Close popover
Nick Carlino (carln)
PEGA
System Architect - Pega Consulting
Pegasystems Inc.
US
carln Member since 2017 1 post
PEGA
Posted: November 12, 2020
Last activity: November 12, 2020

Sorting/ordering on paginated data page

In our implementation, we are sourcing a few personalized tables with paginated data pages (which are in turn sourced by reports) due to the volume of data received.  We have noticed that whenever a paginated data page is ran, it applies an ORDER BY clause to the generated SQL which overrides any ordering or sorting applied to sourcing report definition; specifically "ORDER BY 1 ASC, 2 ASC, 3 ASC...".  This makes it difficult to show the proper data to the user on screen load.  Is this in the works as an enhancement?  Or is there a work-around we are unaware of?

We are currently running 8.4.2

Thank you

Pega Platform 8.4.2 Reporting Manufacturing and High Technology Senior System Architect