Question
Accenture
IN
Last activity: 24 Mar 2017 9:49 EDT
Display Pega pulse Note and Comments in one column
Hi
In pega pulse, for every comment/response added are stored as different row for the same case in the DB, is there any OOTB way to concatenate all the comments for each case id and display it in one cell in the RD?.
***2/28/17,Updated by Maryrita, moderator: moved to Product Support from Applications***
Accepted Solution
Pegasystems Inc.
IN
Pegasystems Inc.
IN
Hello
Well, I dont think such mechanism is available in OOTB way in PEGA.
Any specific reason why you want it to be like this ?
Accenture
IN
Hi Santanu, We have a req to generate an excel with all the case details along with comments, but currently the RD is retrieving multiple row(one for each comment/response) for same case so we need to concatenate all comments and display in one cell.Can this be achieved by SQL func or sub reports... Thanks!!
Accepted Solution
Pegasystems Inc.
IN
Hello
Again, i dont think this can be achieved via any sub report as well.
The best you can do is write your own code to retrieve all the pulse comments and manually do concatenation.
However, a word of caution here, since there is no limit to the pulse comment usage, for one or two comments it might work good, but chances are there that for more than five or six rows, in process of iterating thru all the rows and concatenating them might cause a performance overhead.
Please consult your lead system architect before implementing such design.
Hello
Again, i dont think this can be achieved via any sub report as well.
The best you can do is write your own code to retrieve all the pulse comments and manually do concatenation.
However, a word of caution here, since there is no limit to the pulse comment usage, for one or two comments it might work good, but chances are there that for more than five or six rows, in process of iterating thru all the rows and concatenating them might cause a performance overhead.
Please consult your lead system architect before implementing such design.