Good morning,
I want to ask if it is possilbe, using the smart service Export Data Store Entity to Excel, take the datas I want to export to a Excel, from the process and not from Data Store, ie, I will generate the datas in the process, and I dont have it in data base.
Thank you so much.
Regards, Teresa.
Discussion posts and replies are publicly visible
I believe Appian's current recommended approach is to use Export DSE to Excel anyway. It is possible (despite what the previous commentor said), but requires a bit of a workaround: you would want to create a special database table just to hold this data, and write it there, and then call that table in the Export DSE to Excel smart service. I would suggest making one of the columns "process ID", which you could then use in the query, as I believe process ID will always be unique.
Frankly this use case would be better suited by Export CDT to Excel, which used to be found in the Excel Tools plug-in (until shortly after version 2.0.0), but it's been deprecated for a while now for reasons that were never fully explained.
Hello Mike,
I am trying the option Harsha said, but I am having some troubles, maybe I will try your option too, sounds interesting.