Regarding functionality for exporting grid data made using queried data to excel sheet

Question

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?

Konduru Chaitanya · Accepted Answer

May be you can handle the value in the View itself.

Shubham Aware · Answer

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.

Abhishek Karumuru · Answer

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

Shubham Aware · Answer

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.

Regarding functionality for exporting grid data made using queried data to excel sheet

Top Replies