Pagination on raw table and custom sql query with MS SQL Server

[EvanGllt]

Hello, there!

How do I apply pagination to my raw boards? Because no matter how hard I look at the official documentation, it doesn't apply.

Knowing that I have the same problem for custom requests. I know it's not possible to do this directly, but I can't find anything to help me. I found this (#7313 (comment)) but it didn't work...

I use a MS SQL Server data source.

Can anyone help me? Thanks in advance.

[ConorWebb96]

Hey @EvanGllt,

You may want to look into limit and offset for your SQL queries (I've attached some additional reading you can do on this, that may aid you). You could then attach bindings to these values and then cycle through the pages with buttons that amend the bindings related to your query.

Hopefully this makes sense

[EvanGllt]

Removing the {{ }} braces works, but with the bindings I get an error asking for an int value. Except I can see how I can get around this if I need the bindings. That's weird.

[ConorWebb96]

Since its related to a string being passed into it. Why don't you click the lighting bolt icon switch to JS and return 0 or 5 that way to ensure its a number being passed?

return 0

I think {{ literal 0 }} in hbs should work as well?

[EvanGllt]

I had no choice but to use the text type for bindings :

And return 0 doesn't change anything :

[ConorWebb96]

Ah, my mistake, I thought JS was available. You may need to use CAST or CONVERT to ensure that the values being provided are integers.

[EvanGllt]

It works, but I don't know why the first four rows are duplicated when I only have one row like

[EvanGllt]

Hi,

I found out how to do it.

Here's how I did it for people who are interested :

For my SQL query I added a DISTINCT after SELECT :

I have this component tree :

That's bindings there :

This line in javascript for offset :

For the Back Button :

For the Next Button :

And for Page Field :