Requirement is to fetch Parent Child hierarchy and export the contents to zip file and store in server path.
The parent child instances might be in 3 to 4L records , so if going through loop or recursion in Pega through activity to fetch the hierarchy results will lead to performance .
We went with approach of writing DB query to fetch Parent child hierarchy .
After writing DB query, we have used Connect-SQL to fetch DB query results into Pega.
Now we are storing the results in Code-Pega-List results.
Question here is , how to export the Code-Pega-List results into zipfile and place the zip file in server path .
All ruleset ,Product export code we went through , but these are not helping our requirement.
Can some one assist us on the same?
***Edited by Moderator Marissa to update Content Type from Discussion to Question; update Support Case details***
I figured out the way to package Code-Pega-List results into zip file and place it in StaticFolder/global/export folder.
This can be done using java step .PFA text file with java code written to solve this requirement