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:
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:
I hope this helps!