Sorting non-primary key column in Export Data Store Entity to Excel

Question

Hello, 
 We are using the Export Data Store Entity to Excel smart-service to generate an excel sheet. The requirement is to have the data in the excel sheet sorted by a date column in the descending order. I have defined the ORDER BY clause in the view to handle the data sorting. For some reason, the Export Data Store Entity to Excel smart-service overrides this and generates the excel sheet sorted by the primary key in ascending order. Is there a way to export data into an excel sheet where the data is sorted by a column that is not a primary key ?

Mike Schmitt · Answer

After checking, I can see there are a few previous discussions around this topic here on Community, but so far there are no solid answers I can find. I was mistakenly thinking that the Export DSE to Excel node had a way to accept sorting parameters, but after checking into it, I was wrong. I think the only viable current way of handling this is to create a special view to handle your export, where the primary key is the column you want it to be sorted by. If this is insufficient for you, I suggest opening a support case with Appian to lay out your use case and get them to hopefully fix the Export DSE to Excel node soon.

Sorting non-primary key column in Export Data Store Entity to Excel

Top Replies