Export to Excel

Question

Hi , 
 We have created a Tempo Report, where we are displaying data from Database in Grid Format and we are using fn!getdatasubsetdownloadlinkfromrule() function to get that data in Excel sheet . But if the user is performs sort operation on any fields , and then clicks on Export to Excel link , it is not generating data in sorted format as displayed in grid. 
 How can we achieve this functionality? 
 Thanks 
 Namrata

Mike Cichy · Answer

The datasubset parameter contains a pagingInfo object that you can use to define the sort order. See details here is this page: community.appian.com/.../download-datasubset-plugin 
 
That said, the functionality you are trying to use is now deprecated in the latest version of the Excel Tools plugin. I highly recommend using the out of the box a!EXPORTDATASTOREENTITYTOEXCEL ( docs.appian.com/.../Export_To_Excel_Smart_Service.html)

yeswanththiyarir · Answer

Hi Namratha, 
From what I have understood you are performing the sort operation to view the data in a sorted order. This will not change the order of rows in the database. I think export to excel option works by generating excel from the source from where the data is taken instead of the table that we are viewing. If want your excel to be sorted, try to implement sorting in getdatasubsetdownloadlinkfromrule(). 
Hope this helps. 
Thanks, 
Yeswanth.

Export to Excel

Top Replies