Filtered wiki tables #
Introduction#
Add a %%table-filter JSPWikiStyle around your table to get EXCEL-like column filters. Each column gets a dropdown with a sorted list of filterable values. Multiple filter selections are supported too.
See also Sortable Tables
 |
 |
Usage#
Enclose your table in %%table-filter tags.
Your table is assumed to start with a header row. When all is fine, you should see an additional table row with filter dropdowns for each column.
%%table-filter || Title || Author || Published || Edition || Some IP@ | book1 | zappy | 25 Feb 2005 | 5 | 100.100.100.100 | book2 | dappy | 25 Jan 2005 | 19 | 256.100.100.100 | book3 | pappy | 23 Mar 2005 | 06 | 10.100.100.100 | book4 | dappy | 21 Apr 2005 | 199 | 1.100.100.100 | book5 | rappy | 25 Jul 2005 | 06 | 1.100.25.100 /%
Best Table:#
This seems to be the best table layout: (Shown below)%%zebra-table %%sortable %%table-filter || Title || Author || Published || Edition || Some IP@ | book1 | zappy | 25 Feb 2005 | 5 | 100.100.100.100 | book2 | dappy | 25 Jan 2005 | 19 | 256.100.100.100 | book3 | pappy | 23 Mar 2005 | 06 | 10.100.100.100 | book4 | dappy | 21 Apr 2005 | 199 | 1.100.100.100 | book5 | rappy | 25 Jul 2005 | 06 | 1.100.25.100 /% /% /%
Reality check:
| Title | Author | Published | Edition | Some IP@ |
|---|---|---|---|---|
| book1 | zappy | 25 Feb 2005 | 5 | 100.100.100.100 |
| book2 | dappy | 25 Jan 2005 | 19 | 256.100.100.100 |
| book3 | pappy | 23 Mar 2005 | 06 | 10.100.100.100 |
| book4 | dappy | 21 Apr 2005 | 199 | 1.100.100.100 |
| book5 | rappy | 25 Jul 2005 | 06 | 1.100.25.100 |
| Title | Author | Published | Edition | Some IP@ |
|---|---|---|---|---|
| book1 | zappy | 25 Feb 2005 | 5 | 100.100.100.100 |
| book2 | dappy | 25 Jan 2005 | 19 | 256.100.100.100 |
| book3 | pappy | 23 Mar 2005 | 06 | 10.100.100.100 |
| book4 | dappy | 21 Apr 2005 | 199 | 1.100.100.100 |
| book5 | dappy | 25 Jul 2005 | 06 | 1.100.25.100 |
Implementation#
The implementation was inspired by the work of ~WoutL on
http://www.codeproject.com/jscript/filter.asp
.
Some rework was done, so it also runs on Safari, and does proper sorting depending on the data type of the column.