Passing sorting column name and maximum records to a report definition
HI All,
I'm new to the pega, I have a requirement to pass sorting colum name and maximum records to a report definition through a activity in the runtime. I have tried many options but did not find a way..
Pegasystems Inc.
US
lement,
I think you are correct that this cannot be done; these values would be hardcoded into the report at design time. Instead you will likely need to use a SQL connect rule and pass these values in as params.
If you let me know exactly what you are trying to accomplish rather than how you are trying to accomplish it perhaps there is a better way altogether to do what your activity is doing.
PS Please include what version of Pega you are working in as this would affect the possible solutions.
Let me know if this helps.
Cecil Howell
CSA | Senior Instructor | Pegasystems Inc
Virtusa
LK
Hi howec,
The requirement is like this.. there is a pega soap service that have configured for search data from database. The request that pega getting, contains the sorting column and maximum recods needed in response.
What I have tried is, in the service activity after the request data mapping step I have tried to pass parameters to pxRetrieveReportMetaData activity and after that I'm calling pxRetrieveReportData..
The version I'm using is 7.1.7
Virtusa
LK
Hi all I found a way to solve the above problem
you can use pzGridSortPaginate activity to pass sorting column to sort in the runtime.