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

 Naga Mrudula marthi (Mrudula)
Wells Fargo

Wells Fargo
IN
Mrudula Member since 2015 9 posts
Wells Fargo
Posted: Mar 19, 2018
Last activity: Sep 17, 2019
Posted: 19 Mar 2018 14:02 EDT
Last activity: 17 Sep 2019 12:54 EDT
Closed

CSV format string from a Pagelist property values

Hi All,

I have a requirement to capture list of values of a property which is pagelist and show it in string in a comma separated format in a hierarchy of embedded page lists.

For Ex: I have a property PropertyN in PageListC in the hierarchy pyWorkPage.Page.PageListA().PageListB().PageListC()

PropertyN has values as follows --> pyWorkPage.Page.PageListA(1).PageListB(1).PageListC(1) - P1

pyWorkPage.Page.PageListA(1).PageListB(1).PageListC(2) - P2

pyWorkPage.Page.PageListA(1).PageListB(1).PageListC(3) -P3

and

pyWorkPage.Page.PageListA(1).PageListB(2).PageListC(1) - P1

pyWorkPage.Page.PageListA(1).PageListB(2).PageListC(2) - P4

pyWorkPage.Page.PageListA(1).PageListB(2).PageListC(3) - P5

I have to show a string property PropertyNConcetanted at PageListB level which shows as follows- pyWorkPage.Page.PageListA(1).PageListB(1).PropertyNConcetanted --> P1,P2,P3

Also, pyWorkPage.Page.PageListA(1).PageListB(2).PropertyNConcetanted --> P1,P4,P5

and I have to show a string property PropertyNConcetantedTop at PageListA level which shows as pyWorkPage.Page.PageListA(1).PropertyNConcetantedTop - It should have a property that holds csv values as --> P1,P2,P3,P4,P5 without duplicates.

Show More

Hi All,

I have a requirement to capture list of values of a property which is pagelist and show it in string in a comma separated format in a hierarchy of embedded page lists.

For Ex: I have a property PropertyN in PageListC in the hierarchy pyWorkPage.Page.PageListA().PageListB().PageListC()

PropertyN has values as follows --> pyWorkPage.Page.PageListA(1).PageListB(1).PageListC(1) - P1

pyWorkPage.Page.PageListA(1).PageListB(1).PageListC(2) - P2

pyWorkPage.Page.PageListA(1).PageListB(1).PageListC(3) -P3

and

pyWorkPage.Page.PageListA(1).PageListB(2).PageListC(1) - P1

pyWorkPage.Page.PageListA(1).PageListB(2).PageListC(2) - P4

pyWorkPage.Page.PageListA(1).PageListB(2).PageListC(3) - P5

I have to show a string property PropertyNConcetanted at PageListB level which shows as follows- pyWorkPage.Page.PageListA(1).PageListB(1).PropertyNConcetanted --> P1,P2,P3

Also, pyWorkPage.Page.PageListA(1).PageListB(2).PropertyNConcetanted --> P1,P4,P5

and I have to show a string property PropertyNConcetantedTop at PageListA level which shows as pyWorkPage.Page.PageListA(1).PropertyNConcetantedTop - It should have a property that holds csv values as --> P1,P2,P3,P4,P5 without duplicates.

Can you please suggest the best approach?

***Edited by Moderator Marissa to update categories***


Show Less
To see attachments, please log in.
User Experience

Posted: 6 years ago
Posted: 19 Mar 2018 23:47 EDT
Sreepriya Rao Gona (Sreepriya)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
IN

Hi NagaMrudulam,

You can try using 'pxStringCSVFromPageList' OOTB function to get CSV format string from the pagelist.

eg: @pxDataManipulate.pxStringCSVFromPageList(pyWorkPage.Page.PageListA(1).PageListB(1).PageListC,".PropertyN")  Result -  P1,P2,P3

@pxDataManipulate.pxStringCSVFromPageList(pyWorkPage.Page.PageListA(1).PageListB(2).PageListC,".PropertyN")  Result -  P1,P4,P5

Hope it helps.

Thanks.

To see attachments, please log in.
Posted: 6 years ago
Posted: 22 Mar 2018 10:22 EDT
Naga Mrudula marthi (Mrudula)
Wells Fargo

Wells Fargo
IN

Hi Sreepriya_GCS,

I have done that already for the first level i.e., in PageListC.

But, I need to get the non duplicated data at PageListB level and PageListA as well. suppose from P1,P2,P3 combination and P1,P4,P5 combination we should be able to remove P1 and set the value on PageListB as P1,P2,P3,P4,P5.

Similarly at PageListA level as well.

Thanks,

Mrudula

To see attachments, please log in.
Posted: 6 years ago
Posted: 11 Apr 2018 0:11 EDT
Sreepriya Rao Gona (Sreepriya)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
IN

Hi NagaMrudulam,

In this case, you can run an activity and loop the pagelists to get the required properties into a dummy pagelist.

You can use a when condition on loop to check if the property is already present or not, If yes skip the step execution.

From the dummy pagelist results you can convert it into CSV format string.

Thanks.

To see attachments, please log in.
Posted: 5 years ago
Updated: 5 years ago
Posted: 2 Apr 2019 16:45 EDT
Updated: 2 Apr 2019 16:44 EDT
Jeffrey Silver (JMark515)
Perficient

Perficient
US

Hi, just quick question with respect to this function, it is working for me but the quotes are put into the result CSV string.  If I try it without quotes for the property name I get error. 

To see attachments, please log in.
Posted: 5 years ago
Posted: 3 Apr 2019 9:08 EDT
Pallavi Mandal (Pallavi_Mandal) Senior Technical Documentation Specialist
Pegasystems Inc.
IN
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query.
Show More
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top of this screen and also on our Pega Support Community homepage.  Once created, please reply back here with the URL of the new post.
 
We have also sent you a private message opening up a communication channel in case you have any further questions.
 
Thanks,

Show Less
To see attachments, please log in.
Posted: 5 years ago
Posted: 17 Sep 2019 12:54 EDT
Vaishnavi Batchu (VaishnaviBatchu)
Pega
Vaishnavi Batchu
Pega
IN

 

Hello,

You can try to use the below for building the values for the first two strings.You can try using 'pxStringCSVFromPageList' OOTB function to get CSV format string from the pagelist.

eg: @pxDataManipulate.pxStringCSVFromPageList(pyWorkPage.Page.PageListA(1).PageListB(1).PageListC,".PropertyN")  Result -  P1,P2,P3

Show More

 

Hello,

You can try to use the below for building the values for the first two strings.You can try using 'pxStringCSVFromPageList' OOTB function to get CSV format string from the pagelist.

eg: @pxDataManipulate.pxStringCSVFromPageList(pyWorkPage.Page.PageListA(1).PageListB(1).PageListC,".PropertyN")  Result -  P1,P2,P3

@pxDataManipulate.pxStringCSVFromPageList(pyWorkPage.Page.PageListA(1).PageListB(2).PageListC,".PropertyN")  Result -  P1,P4,P5

For removing the duplicates and building the value of third string you can check the below link.

https://collaborate.pega.com/question/how-set-property-values-comma-separated-values-when-pagelist-contains-duplicates


Show Less
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