a!columnsLayout(columns: {a!columnLayout(contents: {if(isnull(local!exportDocId),/*This link field contains the link that starts the export*/a!richTextDisplayField(labelPosition: "COLLAPSED",value: {a!richTextIcon(icon: "file-excel-o",color: "#6aa84f",size: "MEDIUM")," ",a!richTextItem(text:"Export Customer Report to File",link:a!dynamicLink(label: "Export to Excel File",saveInto: {a!exportDataStoreEntityToExcel(entity: cons!FS_ORDER_ENTITY_POINTER,documentName: "Excel Export " & now(),saveInFolder: cons!FS_constant,onSuccess: a!save(local!exportDocId,fv!newDocument),/*This displays an error if there is an issue executing the the save*/onError: a!save(local!errorMessage,"Error Exporting File to Excel"))}),size: "STANDARD")
}),{}),a!linkField(labelPosition: "COLLAPSED",links: a!dynamicLink(label: "<<<Back",value: null,saveInto: local!exportDocId,showWhen:not(isnull(local!exportDocId)))),if(/*This only displays the download link if a valid document was created*/not(isnull(local!exportDocId)),/*This changes the link to a download link for the newly created document */a!richTextDisplayField(labelPosition: "COLLAPSED",value: {a!richTextIcon(icon: "download",size: "MEDIUM")," ",a!richTextItem(text: "Download Customer Report",link:a!documentDownloadLink(label: "Download Excel File",document: local!exportDocId),size: "STANDARD",style: "STRONG")
}),a!textField(value: local!errorMessage,readOnly: true))}),} )
This is the code am working with for this i want to pass filters so that what ever selecting data it has to show in the export to excel sheet to dwlg. Thanks in advance
Discussion posts and replies are publicly visible
local!data:rule!FS_To_Fetch_Index(customerId:null(),typeOfFruit:null(),fruitSelected:null(),price:null(),storeUser:null(),customerName:null() ), local!fruits:if(rule!APN_isBLANK(local!data),null(),union(local!data.Type_Of_Fruit,local!data.Type_Of_Fruit)), local!exportDocId, local!errorMessage, local!selected:if(rule!APN_isBLANK(local!data),null(),union(local!data.Fruit_Selected,local!data.Fruit_Selected)), local!price:if(rule!APN_isBLANK(local!data),null(),union(local!data.Price,local!data.Price)), local!name:if(rule!APN_isBLANK(local!data),null(),union(local!data.CustomerName,local!data.CustomerName)), local!user:if(rule!APN_isBLANK(local!data),null(),union(local!data.Store_User,local!data.Store_User)),
these are my filters of expression rule , by this way how to add filters to export to excel