a!buttonWidget to execute various functions
Hello,
When I press a button right now it generates a excel file but I want at the same time to generate the excel file and also execute stored procedure, is there such a way, with one click of the button ?
a!buttonArrayLayout(
a!buttonWidget(
label: "Excel",
saveInto: {
a!exportDataStoreEntityToExcel(
entity: cons!BBO_OpportunitiesReportExcelDataStore,
documentName: "Excel Export " & now(),
saveInFolder: cons!BBO_ReportsFolderPointer,
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"
)
),
a!save(
local!staussave,
true
),
}
)
)
And this is the stored procedute code:
executestoredprocedure(
dataSourceName: "jdbc/Appian",
procedureName: "deleteOppExcelData"
),
