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" ),
Discussion posts and replies are publicly visible
Why not just start a process and do anything you like? a!startProcess()
Ok that helped alot I have changed to use buttonWidget where I can use startProcess and now it works.
Thank you !