Question

4
Replies
841
Views
Close popover
Prajakta Vyawahare (PrajaktaV1633)
Infosys Ltd

Infosys Ltd
IN
PrajaktaV1633 Member since 2018 8 posts
Infosys Ltd
Posted: January 29, 2019
Last activity: January 31, 2019
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-sorting-functionality-work-objects-id

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 Support Case Exists
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.