Tablesorter
Tiki uses the Rob Garrison fork of the tablesorter jQuery plugin to add the ability for users to filter, sort, paginate and otherwise manipulate tables used in Tiki. The feature is considered experimental - please report any bugs or wishes.
Features
Tablesorter allows the following to be done without refreshing the page through use of jQuery and Ajax:
- Sorting by clicking on active column headers.
- sorts all items even if only a portion are retrieved from the server and displayed
- Filtering by typing in text or using a dropdown
- all items are filtered even if only some are shown
- Pagination with pager controls
- number of rows shown can be expanded as well
- Sticky headers
- the header row stays visible as you scroll down even when the top of the table is not visible
- Resizable columns
- place your cursor on the right edge of a header cell until the cursor turns into a resize icon - then click and move to the right or left
- Column selector to hide columns
- the button on the top left of the table allows you to hide a column for the duration of the session
- Totals
- automatically add column and table total rows and columns
- Auto hide columns for small viewing windows
Tables where Tablesorter is available in Tiki
Below are the tables for which Tablesorter may be applied. For plugins, Tablesorter is optional even if the Tablesorter feature is activated. For other standard tables in Tiki, Tablesorter is automatically applied if the Tablesorter feature is turned on.
| Feature | Table | Tiki version |
|---|---|---|
| Plugin | PluginFancytable | 12 |
| Plugin | PluginCustomSearch | 16.3 |
| Plugin | PluginTrackerlist | 12 |
| Plugin | PluginList | 15 |
| Users | Admin users list (tiki-adminusers.php) | 12 |
| Groups | Admin lists of groups, group members and users banned from a group (tiki-admingroups.php) | 17 |
| Wiki | List of wiki pages (tiki-listpages.php) | 14 |
| Forum | List of forums (tiki-forums.php) | 14 |
| Forum | Topic list for a forum (tiki-view_forum.php) | 14 |
| Forum | Admin forums (tiki-admin_forums.php) | 14 |
| Payment | Payment tables (tiki-payment.php) | 16 |
Prerequisites
In order to use tablesorter,
- Javascript must be enabled
- Enabled by default at Admin > Features > Programmer (tab)
- jQuery Sortable Tables must be activated
- Enable at Admin > Features > Interface (tab)
- For the server parameter to work for a plugin, and to apply tablesorter to any tiki table that is not a plugin, ajax must be enabled.
- Enable at Admin > Features > Interface (tab)
Parameters
Below are the parameters that are used for plugins where this feature is available. See the related plugin documentation pages for more information and examples.
tsortcolumns also accepts type nosort
Samples
Tablesorter is an addition to another feature to see samples please follow those links;
Plugin FancyTable Sorting Filtering and Paginating
Plugin FancyTable Automatic Totals
Plugin List Table formatting with tablesorter
;){kind=link}