Skip to main content
May 20, 2022
Question

How to add filters to the export to excelsheet

  • May 20, 2022
  • 2 replies
  • 0 views

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

2 replies

May 20, 2022

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 

gopalk2865
Participating Frequently
May 20, 2022

Please dont initiate multiple threads for the same question.