Question

4
Replies
738
Views
PrajaktaV1633 Member since 2018 8 posts
Infosys Ltd
Posted: 1 year ago
Last activity: 1 year 7 months ago
Closed
Solved

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:

https://community.pega.com/support/support-articles/inconsistency-sorti…

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***

Low-Code App Development Reporting SR Exists
Moderation Team has archived post
Share this page LinkedIn