Hi All,
I have a process which uses "Export SQL to Excel" Smart Service and fetches data from the db and creates a excel sheet. When using this - generate report, we are creating a select query - SELECT ID AS Number AND LABLE AS 'Label Name' FROM ABC_TEST table (multiple tables with joins to create almost 172 columns), and the plug-in smart service uses these alias names and creates header into the template excel that is - in excel you can see 1st column ('Number') & 2nd column('Label Name') as But after Appian upgrade 25.3, this alias is stopped and it is now taking direct table column names that is - ID & LABEL in excel header.
Anyone has seen this issue and have any work around, please help/suggest.
Thanks in advance.Note - this is user requirement where excel download report has almost 172 columns data which is used for further reporting. It was working very great before this upgrade but after upgrade it is just working with column header as like table header which is not desired.
Discussion posts and replies are publicly visible
As you already know, "Export SQL to Excel" is a plugin function, so generally this issue occurs with newer versions, and the plugin owner needs to update the plugin to provide support. I would recommend creating a database view with aliases and exporting from that view.
Thanks Shubham, we had already tried using view and again it's a query slowness and timeout issue were observed and again if we use view with alias to it, still the alias will not supported.