Question
bitsinglass
IN
Last activity: 17 Apr 2024 12:02 EDT
how to sort data from datapage in pega
Datapage contains list of pages, based on one column I want to sort all pxResults of datapage, is this possible in pega?
can we use obj-sort method here?
Source of datapage is activity and when tried using obj-sort i am getting below error
The reference D_**_**.pxResults is not valid. Reason: Complex property references are not allowed as PageListProperty.
***Edited by Moderator Marije to change type from Pega Academy to Product; update capability tags***
Accepted Solution
Updated: 17 Apr 2024 12:02 EDT
Pegasystems Inc.
CA
Maantic Inc
IN
If the data page is sourced from a report definition, then you can directly add the sort in the report column. Else you can add a response data transform. In the DT you can add a sort step on Primary.pxResults directly.
If you want to use obj-sort, then you need an activity. If so then yes you can use obj-sort on <your D page>.pxResults.
bitsinglass
IN
Source of datapage is activity and when tried using obj-sort i am getting below error
The reference D_**_**.pxResults is not valid. Reason: Complex property references are not allowed as PageListProperty.
Maantic Inc
IN
.Is the reference correctly provided in Pages & Classes? Is the data page present in the inheritance path of the activity from where the activity is called from?
Accepted Solution
Updated: 17 Apr 2024 12:02 EDT
Pegasystems Inc.
CA
SiXworks
GB
@VivekK16711353 As you are getting your data from an activity, you could do this in one of two ways.
First option is to use Obj-Sort in the activity that is getting the data.
The second option is to call the Sort activity in the Post load processing section on the data page (this is just under the data sources section)