I am looking for a way to export cdt list to excel from an interface using a single click download option. Do not want to store this data into table. Please suggest.
Discussion posts and replies are publicly visible
The older versions of the Excel Tools plug-in (2.0.0 and earlier) had the Export CDT to Excel node which worked well, but this has been deprecated, and so far we are still waiting to be provided a sufficient replacement.
[They did provide the Export DSE to Excel smart service, out-of-box, which has some very nice features, but it also has severe limitations in comparison, such as your issue (needing data to come straight from the DB as a potential hinderance), as well as the complete inability to export data nicely on top of a provided base template and creating a new file.]
In addition, the query limit of 1 MB remains with the new service. We've been migrating to Export SQL to Excel with much better success.