This is my usecase. i have editable grid of data and also providing user to do the (custom) filter and sorting. But now user want the export those data into excel.we have used EXPORT DSE to Excel smart service to do that. But here the challenges is user applied sort is not working when we export the data.
I don't know how to configure that. Can anyone help me here.
Discussion posts and replies are publicly visible
There are multiple ways to handle this but i would recommend,
Create Staging table then, Collect user interface actions like sorting and filtering, and use those values to create a dynamic expression for querying and writing data to the staging table using PM. Then, use Export Data Store Entity to Excel to retrieve data from the staging table, and delete the same data afterward.
Make sure that if you have concurrent user sessions, use userId as an identifier to export and delete the correct data for each user.
My current recommendation is the newer plug-in, Export JSON to Excel. It sidesteps a lot of the artificial limitations of DSE to Excel (sorting, lack of support for a base template, etc), and doesn't require the painful workarounds like creating a staging table, etc. You can just query your data, do whatever local transformations on it you'd like, wrap it up as JSON, then pass it into the node.