Hi guys,
I have a question that I have a List of CDT return from a expression rule, i need to export data with in that list by EXCEL format.
a!exportDataStoreEntityToExcel( saveInFolder: cons!DSBX_FOLDER, documentToUpdate: todocument( local!exportDocId ), documentName: if( rule!GBL_isBlank( local!exportDocId ), trim( concat( " Tasks Export - ", now() ) ), null ), includeHeader: true, entity: local!gridDataSP, selection: a!querySelection( a!queryColumn( field: "firstName" ) ), onSuccess: { a!save( local!exportDocId, fv!newDocument ) }, onError: { a!save( local!exportDocId, null ), a!save( local!exportError, true ) } )
local!gridDataSP is that List of CDT.
Please give me some help, thanks guys!
Discussion posts and replies are publicly visible
This is not export CDT to excel, this is export DB data (DSE) to excel. You would have to first write your data to the DSE and then use the export. Other option is to create the document from the data and save it to a folder, then provide the download link for the document to the user.