Hello,
we are exporting DB data to excel where we have one column for Appian user id .we are using a!exportDataStoreEntityToExcel to export whioch igives all the columns as it is which are in DB but we want to convert Appian user id to first name and last name before dumping to excel.
Is there any way I can do it using a!exportDataStoreEntityToExcel without saving first name and last name in DB.
Any pointer will be helpful.
Thanks in Advance.
Discussion posts and replies are publicly visible
Hi Jeevika,
I don't think there is a way to manipulate your data in Appian before exporting to excel using this function a!exportDataStoreEntityToExcel. You can try to use the export to excel smart service to pass your data from Appian UI to the smart service and on the UI you can use the user function to fetch your first Name and last name and save the in a dummy CDT and pass that CDT value to your smart service to export the data through link.
Regards,
Vinita
Hai vinita,
i hope you are aware that a!exportDataStoreEntityToExcel doesn't allow to export data from CDT here you can directly export from DB using entity
Jeevika,
That is what i have told in the first line and hence suggested an alternate approach requesting you to go through and see if that works for you.
I recommend using records. With a!gridField() using a record type, you can export all data to excel and it will keep the format of the grid columns
We will typically do this with a view on the database which joins the user ID to a "Users" table containing the names, and concatenate them in the view, then you can smoothly use a!exportDataStoreEntityToExcel() on the view.
Also to note, the Export CDT to Excel service has been deprecated - although many of us are still forced to use it in production since no matching functionality exists OOTB.