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***
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!!
Posted: 6 years ago
Posted: 9 Mar 2017 10:42 EST
Santanu Bhattacherjee (Santanu)
Senior Manager, Cloud Engineering, Management Plane Services
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.