[xwiki-users] Pagination macro with sortable table

Hello, I would like to know whether is possible refresh table data when I change column for sorting. Now, when I click to sort by some column, table is sorted with actual table data, not with all data. I expect that is needed to add "order by" to sql query, but what else should I add? If this is not possible could I use livetable with data from sql query? Thank you Here is my code: $xwiki.ssfx.use("js/xwiki/table/table.css") $xwiki.jsfx.use("js/xwiki/table/tablefilterNsort.js", true) #connectDbTEP($dbc) #countRooms($pocetMistnosti) #set($paginationParameters = { 'totalItems' : $pocetMistnosti, 'defaultItemsPerPage' : 15, 'url' : $doc.getURL('view', $queryParams) }) #pagination($paginationParameters) <table id="searchResults" class="grid sortable doOddEven"> <tr class="sortHeader"> <th>Místnost</th> <th>Zodpovědná osoba</th> <th class="unsortable">Operace</th> </tr> #foreach($row in $dbc.executeQuery("select id_room, mistnost, prijmeni, jmeno from room, osoby where room.id_os = osoby.id_os limit $paginationParameters.firstItem, $paginationParameters.itemsPerPage")) <tr> <td> $row.getString("mistnost") </td> <td> $row.getString("prijmeni") $row.getString("jmeno")</td> <td> EditRoom?id_room=$row.getLong( DeleteRoom?id_room=$row.getLong( </td> </tr> #end </table> #set($discard = $paginationParameters.put('position', 'bottom')) #pagination($paginationParameters) -- View this message in context: http://xwiki.475771.n2.nabble.com/Pagination-macro-with-sortable-table-tp57… Sent from the XWiki- Users mailing list archive at Nabble.com.