I have created a read only grid using queried data. Now I want to export it to the excel sheet. Besodes, I am also able to export it to the excel sheet using export data store entity to excel smart service. The issue is I have a column active date in the database table as "date timestamp" but I want it as only "date value" in the sheet. And this should be done automatically when someone clicks export to excel. How can i achieve this formatting?
Discussion posts and replies are publicly visible
hi swapnilk0010 are you using view in your database?
Abhishek Karumuru Yes
May be you can handle the value in the View itself.
it think so he is using same view for in grid and as well as export.
swapnilk0010 If you are using same view multiple places i would suggest you to create new view and change definition from timestamp to date for that column and use new view to export.Make a use of DATE() function in view to convert dateTime to Date.
Then having two columns on which displays as a date time and other as date value.
Then I think how can we differentiate while exporting the data, when you use export data store entity to smart service it would take whole structure of the view
Okay, Just a thought can try export sql to excel smart service, export purpose so that view will not be disturbed. you can do manipulation in your sql script changing date time to date
Abhishek Karumuru For exporting data to Excel skip the "Export SQL to Excel"(External Plugin). The "Export Data Store Entity to Excel"(Appian Built In) is faster, handles large datasets smoothly, and is way more secure. It's also easier to use and keeps your exports up-to-date with future Appian versions.I know he need to create new view but for future version and Appian support it would be better choice.