Question

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

Forum|Forum|2 years ago
April 19, 2024
13 replies
0 views

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?

karumurua531442

hi [mention:2b38d12ffa9e4814b6cfcc9f64da75bc:e9ed411860ed4f2ba0265705b8793d05] are you using view in your database?

S

swapnilk234861Author

[mention:3510a5189ce1477eaf2e09f5858c87e9:e9ed411860ed4f2ba0265705b8793d05] Yes

konduruc733182

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

harshk1671

If you create your grid using Appian record, it will give you 'Export to Excel' functionality of record OOTB. For changing format of "date timestamp", you can create a custom record field.

S

swapnilk234861Author

But I'm not using Appian record to create grid. I was using view for the grid.

harshk1671

In that case you can create an Appian record from that view keeping 'Sync' disable. Use this record to create paging grid so that you can use OOTB export to excel functionality. Convert format of data timestamp in database view.

Still recommended approach is to use record sync(s). docs.appian.com/.../Records_Tutorial.html

Sign up

Login with SSO

Login to the community

Login with SSO