I am exporting data to excel using "exportDataStoreEntityToExcel" Smart service.
I have to sort the data using one of the column in Database,
Please can you suggest is there a way to sort the data using any column other than Primary Key?
Discussion posts and replies are publicly visible
I guess the only way to export the sorted data (for now) is adding the ORDER BY in view itself.
No, sorting inside the DB doesn't help, because in this Smart Service Appian is automatically sorting ascending based on the primary key defined in the CDT.
Afaik at the moment there is no option to set up custom sorting inside this specific Smart Service. So the only workaround would be to create DB view only for export purposes and set the primary key in the CDT on the column you want to sort by, as suggested here: https://community.appian.com/discussions/f/general/18339/sorting-non-primary-key-column-in-export-data-store-entity-to-excel
© 2021 Appian. All rights reserved.