Custom Query: Paging and Sorting

Wappler General Need Help
1

I thought I saw this topic awhile back but can’t seem to find it.

How would one go about adding paging and column sorting to a custom query?

2

I am also interested in adding paging to custom query…

3

I suggest you to check the MySQL docs about LIMIT and OFFSET:

https://www.w3schools.com/php/php_mysql_select_limit.asp

There are plenty of resources in the internet explaining how to use them.

1 Like
4

Thought there might be a Wappler way to do it. I will investigate, thanks!

5

That’s the Wappler way :smiley:
It’s a custom query after all. Wappler doesn’t know what and how you are going to write it.

1 Like
6

The Wappler way is the paged query action, using the custom query action lets you implement your own way of paging. So start studying SQL :wink:

3 Likes
7

If using a custom query, and putting in offset and limit values with variables, Wappler doesn’t make those available like it does with a paged query, does it?