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-tp5787879p5787879.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
