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 -- First appeared in BrushedTemplate Jan 06, added to JSPWiki since v2.5.xx. DF, Sep 07.

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
/%

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. Tx for the suggestion by Nascif Abousalh Neto -- 19-Jan-2006

Some rework was done, so it also runs on Safari, and does proper sorting depending on the data type of the column.


Is there anyway to somehow adjust the width of table? I noticed that when I choose to use table-filter, width of the table just explodes. Even %%(width:950px) seem to not help at all.

--AnonymousCoward


How can I exclude some columns from filtering?

--pihentagy

You can't. When a column contains only 1 value, no filter dropdown will be shown - DF


Category.Documentation