Paging in confluence sql plugin

Question

I have SQL Plugin for Confluence and I use it to display information from the table from MSSQL server.

I have limit option set to 300 in plugin configuration, but the table size encreases and now it has more that 300 rows. Is it possinbe to set up something like "paging" in macro settings? I mean that I can see first 300 rows selected then I click "next page" and I can see next 300 rows (301-600).

I can create new page with the same query and additional limit/offset but it is not ok, as later I'll need to create next page by hand and so on.

Adrien Ragot 2 · Answer

I've published another plugin, Play SQL (free for read-only mode), which has pagination. See screenshots at https://playsql.atlassian.net/browse/PLAYSQL-19

Christian Schlaefcke · Answer

As I also think this would be useful I opened the requested improvement. Please vote if you also think this would be useful.

Bob Swift · Answer

No, not currently. Please open an improvement request. Unfortunately, it is not as simple as you may think.

Consider using the Cache Plugin for Confluence and allow the whole table to be displayed with less impact on the system.