how to use formated description of Case Audit for Report?
I want to use formatted Message (pyMessageKey) in report / report definition however Message (pyMessageKey) in DB is like below and not formatted well.
[xxx-work-xxx]ItemCreated
[xxx-work-xxx]AssignmentCompletedDataEntry
[xxx-work-xxx]AssignmentRoutedManager xxxx
I can use substring function for cutting [xxx-work-xxx] part but Message (pyMessagekey) dose not have space between words.
This seems to be available for Audit trail like this.
It seems it used Data Page: D_WorkHistory, which source an activity and it linked many other activities.
Dose anyone know how we can use formatted pyMessageKey in Report (Report definition)?
I want to use formatted Message (pyMessageKey) in report / report definition however Message (pyMessageKey) in DB is like below and not formatted well.
[xxx-work-xxx]ItemCreated
[xxx-work-xxx]AssignmentCompletedDataEntry
[xxx-work-xxx]AssignmentRoutedManager xxxx
I can use substring function for cutting [xxx-work-xxx] part but Message (pyMessagekey) dose not have space between words.
This seems to be available for Audit trail like this.
It seems it used Data Page: D_WorkHistory, which source an activity and it linked many other activities.
Dose anyone know how we can use formatted pyMessageKey in Report (Report definition)?
Thank you in advance.
Hello Ryosuke,
Can you create a control, non-autogenerated, use the below code and apply it to the RD pyMessageKey column
<%= tools.getLocalizedTextForString("pyWorkPage.pyHistoryMemo", tools.getActiveValue())%>
I tried a test with the above and it seems to work ok me, let me know how your test goes.
Thank you,
Sunny
Pegasystems Inc.
AU
Hi Sunny,
Thank you for your advice on this.
It worked once but dose not work anymore. It seem this function is page dependent.
I would like to modify this to work in my report because this seems to be a good start toward our goal.
Would you be able to tell me what are these?
<%= tools.getLocalizedTextForString("pyWorkPage.pyHistoryMemo", tools.getActiveValue())%>
Q1. pyWorkPage.pyHistoryMemo
What dose this reference? When we run report, it normally run in thread, so there is no pyWorkPage, right.
I also could not find .pyHistoryMemo.
Q2. Where I can find "getLocalizedTextForString" in PRPC?
I would like to see what actually doing.
Thank you,
Ryo
You are right, I just wanted to try something very quick so I used the pyWorkPage reference. Tell me how are you running your report exactly? Are you launching the report from the report browser in the end user portal? I had a repeat grid in my work object that was using RD as the source.
getLocalizedTextForString() is engine api and you will not have access to it, it is not a function rule that you can open up in PRPC.
Thank you,
Sunny
Pegasystems Inc.
AU
Hello Santosh,
Yes, we run the report from Report Browser like this. So
As you see, Message dose not properly formatted such having no space between words.
If you could tell me what page to use on the clip board, then I could check and test what to do.
I also understand about "getLocalizedTextForString() ". Thank you for your explanation.
