I am connecting to Cloud SQL database and getting data using RDB list method and able to get results on clipboard i.e LolRepeatsPage.pxResults and same reference i have used to show data on Repeating grid shown in the attached document.
I have an requirement to show the data and export the same in excel format. Since i am not storing the results in local pega database what is the best way to export the data in excel format.?
i have used 'pxConvertResultsToCSV' OOTB activity and able to export the data in the csv format but the last 3 digits chaging to zeros.
Please refer the attached file for more details and kindly let me know if any other OOTB activity can be used?
Thanks for replying.I am using 'pxResultsConvertCSV' OOTB activity and using parameters from 'LolRepeatsPage.pxResults' page,but the last 3 digits in 'MersMin' changing to zeros as mentioned in the attachment.