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?