Question
Cognizant solution Technology
IN
Last activity: 20 Apr 2020 6:35 EDT
Exporting report definition data to CSV file
Hi Pega friends,
can anyone help me here!
In UI I have created a table layout and provided source Data page with source report definition.
Hi Pega friends,
can anyone help me here!
In UI I have created a table layout and provided source Data page with source report definition.
1. Report definition - joined to table (Worklist table and Member table)
2. I'm fetching the results, I have a requirement export this to CSV file.
3. created a pagelist and called pxConvertResultsintoCSV OOTB activity. in this OOTB activity Parameter
I have added CSV Property- pyID,pyCustomer,ProviderID,pyFullName,PrimaryState,LOB,AppealType,Progress,pyStatusWork,Approvalprobability,pxAssignedUserName
Here Provider ID,pyFullName,PrimaryState,PxAssignedUsername are joined class property
4. When I try to give it as just pyFullName/Primarystate- value in the excel is EMPTY for the respective property
When I try to give Member.pyFullName- it throws error.
can anyone know how to rectify this? I tried giving with a comma, it is throwing error ("Member.pyFullName")
Pegasystems Inc.
IN
Hi,
Can you try copying the Report results into a pagelist(temporary one) and Create a data transform to set the parameters required for pxConvertResultsintoCSV and try the running the pxConvertResultsintoCSV by giving the step page as the temporary page list. You cannot directly use the Member.pyFullName
Cognizant solution Technology
IN
In the Data Transform, I created new property add existing page list property and called the pxconvertresultsintocsv required parameter and it is working.
Thanks for the idea!