Question
Infosys Ltd
IN
Last activity: 31 Jan 2019 7:15 EST
Sorting Case IDs numerically instead of alphanumeric way
Hi Team,
We are using Inbuild Pega Reporting structure to show Reports in our application. Client wants Report to be sorted on the basis of Case IDs in numerical order. But Pega is sorting Case IDs aplhanumerically even though if i try to do sorting in report definition.
For example my case IDs are shown in below seqence
O2I-1
O21-10
O2I-101
O2I-102
O2I-11
But Client want it to be in below sequence:
O2I-1
O21-10
O2I-11
O2I-101
O2I-102
For the same i have raised SR-C86658 and in that they have provided solution to create new control and function as specified in below link:
But in this link the Case ID is appended by providing harcode value. Instead of that i want to use pyWorkIDPrefix as we are having 7 application and i don't want to harcode it.
Below is the control that we have created:
{%
ClipboardProperty cp = thisRef().getClipboardProperty();
ClipboardPage pg = tools.findPage("pyWorkPage");
String appname = pg.getProperty(".pyWorkIDPrefix").toString();
tools.appendString(appname + cp.toString());
%}
When i use this control i am not getting anything in Case ID column.
Hi Team,
We are using Inbuild Pega Reporting structure to show Reports in our application. Client wants Report to be sorted on the basis of Case IDs in numerical order. But Pega is sorting Case IDs aplhanumerically even though if i try to do sorting in report definition.
For example my case IDs are shown in below seqence
O2I-1
O21-10
O2I-101
O2I-102
O2I-11
But Client want it to be in below sequence:
O2I-1
O21-10
O2I-11
O2I-101
O2I-102
For the same i have raised SR-C86658 and in that they have provided solution to create new control and function as specified in below link:
But in this link the Case ID is appended by providing harcode value. Instead of that i want to use pyWorkIDPrefix as we are having 7 application and i don't want to harcode it.
Below is the control that we have created:
{%
ClipboardProperty cp = thisRef().getClipboardProperty();
ClipboardPage pg = tools.findPage("pyWorkPage");
String appname = pg.getProperty(".pyWorkIDPrefix").toString();
tools.appendString(appname + cp.toString());
%}
When i use this control i am not getting anything in Case ID column.
Is this approach incorrect? Is pyWorkIDPrefix not compatible with this?
Thanks,
Prajakta
***Edited by Moderator: Pallavi to update platform capability tags***
***Edited by Moderator Marissa to update SR Details***
Accepted Solution
Areteans
IN
Hi Prajakta,
This is not the correct format of the control. When this control is getting executed you won't have the "pyWorkPage" as the step page. So you will never get the property "pyWorkIDPrefix".
Instead of that you can have application specific report definitions to show the IDs in numeric and sorted.
Thanks
Kamalesh
Updated: 30 Jan 2019 12:17 EST
Pegasystems Inc.
US
Hi @PrajaktaV1633,
I was just reviewing your Support Request and I see that you wrote in that your question was resolved here in the PSC. Was it @KAMALESH_TECH's reply that resolved this for you?
Thank you!