Download as Excel (.xlsx) of all pages of server-side paginated table

Hey there,

Is there any possible way (or maybe tricks) to download data as Excel (.xlsx) of all pages from server-side paginated table?

Hey @yeftanma! One approach might be to use a separate query on your resource, similar to the query that populates your table but without any OFFSET and LIMIT clauses (assuming that's how you're doing your server-side pagination). You could then add an event handler on success of the query to export the data:

Screenshot 2023-04-06 at 19.57.57

You can call the file name whatever you want, in this case I've used a string literal that calls it "query1_data_{YYYY_MM_DD}"

That query should be configured to trigger manually (when someone needs the exported data), with the option to run on page load deselected. You could use a button with an event handler:

Screenshot 2023-04-06 at 19.55.16

I hope this helps!