jspωiki
Filtered Tables

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.