Multiple sortable with dropdown (no "table generator")

That is actually really easy.
Create a Paged Query, it will generate the required GET variables for you:

limit - the number of records per page
sort - the column to sort by
dir - the direction

Add your columns to the query builder:

On your page create your 3 selects menus.
Select for sorting - having your column names as values:

Select for direction - having ASC and DESC as values:

Select for number of records shown … having numbers like 10, 20100 as values:

Finally when you add the server connect component on the page, select your server action with the paged query and you will see the GET vars there in the Properties panel.
Bind the value of each select in the corresponding GET var.

When the selects values change, the data will be updated automatically.

1 Like