I have a Data got from a view with selection and filtering and displaying in a Grid. Now i need to have button in that interface to call export to excel. This interface is a report in Tempo. I am not able to use
a!exportDataStoreEntityToExcel function because i have a data, again i cannot configure to get data, because it is a large set of data, getting time out from Database. But i have already tuned performance of that query in separate expression rule.Please let me know how to pass datasubset to excel for 19.2 version
Discussion posts and replies are publicly visible
You can set the queryfilter. see https://docs.appian.com/suite/help/19.2/Export_To_Excel_Smart_Service.html#a!exportdatastoreentitytoexcel()
If size and parameters are an issue, you could put this into a PM where the doc is either emailed or placed into a folder for pickup. Use a!startProcessLink and pass in filter values as processParameters. Using the export datastore to excel will keep the data out of memory too in the PM. Just an alternative to think about.
© 2020 Appian. All rights reserved.