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
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.