How can get sorted data in Export to excel

Certified Lead Developer

Hi,

 I have requirement to export the data from table in sorted order for given field. 

I tried with below scenarios 

1. Export Data Store Entity to excel, but i cant see any sorting input 

2. Export SQL to Excel, but its deprecated, so cant use.

Please suggest any solution, if you have came up from this problem .

  Discussion posts and replies are publicly visible

Parents Reply Children
  • 0
    Certified Associate Developer
    in reply to Saurabh Rajnala

    Hi Saurabh,

    You were able to solve your problem, right now I have exactly the same problem and I don't want to use the "Export SQL to Excel smartservice"

  • 0
    Certified Lead Developer
    in reply to auroraj5980

    Duplicate of

    I am generating an excel with Export DSE to EXCEL. The smartservice consults a view with the data ordered by a date field. The result obtained in the smartservice is ordered by id (PK), not by date. How…
    By in Discussions > Process
    1 reply

  • 0
    Certified Associate Developer
    in reply to auroraj5980

    Retrieving that data, sorting it and then using Export DSE is the only thing I can think of, maybe you can use an auxiliary table and delete its contents once you finish the export to Excel. I don't know if it's too far-fetched...