Hi gurus,
I would like to check how to enhance the download excel report function.
I got the about 50 DB columns need to be downloaded and some of column contain multiple value with splitting by ";", so the String_join function also be used.
However, when i click the download button, system will take about long time to proceed and sometimes will hit the error below.
May i know how to improve the code to get better download experience, attached the download action flow below for your reference.
Hello @Giselle Chen ,
This seems to be running on a client screen action, move the logic to a Server Action if possible. Server actions handle large datasets more efficiently and help avoid client-side timeouts. Additionally, by using a server action, you can avoid refreshing a full aggregate when you only need a specific attribute.
Thank you Mihai, it works after change it to server action.
Hello @Giselle Chen,
As Mihai mentioned, its better to move your logic to server action and just return output of this action either the list of data or binary data to download.
Regarding the error it seems you are trying to change into the list that you are iterating which is output of data action into last listAppend into iteration. Another reason may be any other action on the screen refreshing same data action.
Thank you Mostafa, it works after change it to server action.