Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Varun Chandana (VarunC72) Infosys Ltd
Infosys Ltd
IN
VarunC72 Member since 2016 9 posts
Infosys Ltd
Posted: Jan 17, 2019
Last activity: Jan 25, 2019
Posted: 17 Jan 2019 7:03 EST
Last activity: 25 Jan 2019 7:49 EST
Closed
Solved

How to Show PageList as CSV in Report definition Column

Hi,

We have a pagelist with the comments entered by the user. Now in a report Definition the user wants to see all the comments entered as CSV in one of the Report column.
My Approach:- i am thinking is to set some flag property and keep appending the new comments to this property and display this property in the Report. But the issue will be with the old cases where i have to run an external activity to set this property and i have cases more than 200k.

We already have declare index on this Page list.
So Can any 1 suggest me if there is any better approach for this.


PRPC version 7.3.1


Thanks,
Varun.

***Edited by Moderator Marissa to update platform capability tags****

To see attachments, please log in.
Reporting

Accepted Solution

Posted: 5 years ago
Posted: 25 Jan 2019 7:49 EST
Varun Chandana (VarunC72) Infosys Ltd
Infosys Ltd
IN

I have created a Function Alias and Used Oracle LISTAGG function for this requirement .

(SELECT LISTAGG("PC".pyLabel,',') WITHIN GROUP (ORDER BY "PC".pyLabel) AS "Record" From TableName "PC"   WHERE "PC".PYID = {1})

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice