And could I use there data from MySQL db through sql plugin? I have looked for this usage but did not find it.
2010/11/30 Jerome Velociter <jer...@xwiki.com> > Hello tomasg, > > If you want to have dynamic sorting and filtering, you should rather > use the LiveTable component/macro > > Checkout : > * http://code.xwiki.org/xwiki/bin/view/Macros/LiveTableMacro > * http://platform.xwiki.org/xwiki/bin/view/DevGuide/LiveTable > > Cheers, > Jérôme > > On Tue, Nov 30, 2010 at 1:17 PM, tomasg <tomas.gr...@gmail.com> wrote: > > > > 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 > > > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
