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
Yes, you can request all the information from the database and later use the updateCDT function to update on each element of the multiple CDT the date, with a transformation. The last step is call the CDT to Excel plugin.
CDT to Excel was deprecated last year at some point, so the only way to use it now is to have (or find) an old version of the plug-in (2.0.0 or earlier), which is obviously not "officially" supported by Appian obviously.
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.