Sorting upon exporting table data

I am trying to sort (ASC) from a table in ignition. How can I do this. My MYSQL query that displays the data is already sorting it ASC however when I pull the data up in excel it is DESC. Also, is it possible to export the data as it is being currently being displayed by the end user. For example, if the user sorts it by date and then exports it can I have it import into excel in the same way that it was being sorted?


Jason Foster

Any idea on how this could be accomplished?



how are you getting it from the table to Excel?

Table component sorting is not reflected in the underlying dataset. If it is the table’s dataset (or any system dataset) that you are trying to export, you can first sort it with system.dataset.sort ( … t_sort.htm)