Hello,
We are using the "Export Data Store Entity to Excel" smart service. Our datetime values in the database are all saved as GMT, but when we export to Excel, we want the users to see the datetimes in their local timezone. In the queryEntity within this smart service, is it possible to query the datetimes and have them appear in the Excel as the users' local times? The only information we have on the user is the username who started the process.
Thank you!
Discussion posts and replies are publicly visible
I know, but you could find it i suppose. By the way you can develop a new plugin to cover this kind of requirements and shared it later with the community.
The Export Data Store Entity to Excel smart service was introduced in Appian 18.2, as best I remember - so I'm unclear what you're currently trying to use, but batching would need to be handled manually which will probably be difficult.