How to create zip file with Code-Pega-List result
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?