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.
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
He would have to use Export SQL to Excel