Table Filter add-on allows you to filter the data presented in tables. Data filtration can be applied to one or several columns at a time. Just paste your table into the Table Filter macro and set the required columns for filtration.
Try the following use cases:
- Generic table data filtration
- Default values for filtration and regular expressions
- Table filtration by the user-entered keyword
- Global filter
- Filtering multiple tables at once
- Filtering the number range
- Filtering the date range
- Changing the width of the filter boxes
- Hiding the filters
- Fitting table to the screen area
- Hiding table columns
See the next pages for advanced usage of Table Filter add-on and check its compatibility with other add-ons and macros:
Table Filter for Confluence
Other Add-ons for Confluence
Parameters
The add-on adds the Table Filter macro. You can add this macro onto your Confluence page and further paste one or multiple tables into the Table Filter macro body. You can also insert the macros that generate the table data. The following parameters are available to you:
Parameter | Parameter Name | Default | Description |
---|---|---|---|
column | Dropdown Filter Columns | The columns by which the table should be filtered. While using filters by several columns simultaneously, their names should be divided by comma. | |
userfilter | Free Text Filter Columns | The columns by which the table should be filtered with the user-entered keywords. While using filters by several columns simultaneously, their names should be divided by comma. | |
cell-width | Set Width of filters | 150 | This option allows you to define width in pixels for each filter on the filtration pane. |
button | Hide Filters by Default | false | This option allows you to collapse the filtration pane by default. |
hidelabels | Hide Filter Labels | false | This option allows you to hide labels of filters on the filtration pane. |
default | Set Filters' Default Values | The default values for drop-down filters and textboxes, which the table should be filtered by. | |
limitHeight | Fit Table to Screen Area | This option allows you to enable the fitting of the table to your screen area. | |
globalFilter | Global Filter | false | This option allows you to enable the global filter for instant data filtration throughout the whole table. |
numbering | Automatic Row Numbering | false | This option allows you to enable automatic row numbering. |
showNRows | Show First N Rows | This option allows you to specify the number of rows to show. | |
numberfilter | Number Filter Columns | This option allows you to filter the columns with number values within the specific range. | |
datefilter | Date Filter Columns | This option allows you to filter the columns with dates within the specific date range. | |
datepattern | Date format | This option allows you to specify the appropriate date format for filtration by date range. |
Examples
Generic table data filtration
Please select one or multiple values to filter data in the table below.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Default values for filtration and regular expressions
Please note that Table Filter allows you to define default filter values for table columns. These values will be automatically applied upon each reload of the page. You can also use regular expressions for flexible data filtration.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Table filtration by the user-entered keyword
Please note that Table Filter allows you to add free-text fields for dynamic data filtration depending on the specified query.
Try to start entering some values for filters to get dynamic filtration of the table.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Global filter
The Global Filter allows you to dynamically filter values in all columns of your table. Enter some query to get the table filtered.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Filtering multiple tables at once
You can filter several tables at a time. Just paste two or more tables into the macro.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Last Name | First Name | Occupation | City |
---|---|---|---|
Brown | Adam | Developer | New York City |
Fry | Andy | Delivery boy | London |
Black | Jane | Scientist | Tokyo |
McCarthy | Hubert | Scientist | New York City |
McCarthy | Cubert | Student | London |
Filtering the number range
Table Filter allows you to filter numbers in your tables. Just select the appropriate number range or minimal/maximal value and get the table data filtered.
Customer | Minimal Purchase, $ | Maximal Purchase, $ | Average Purchase, $ |
---|---|---|---|
Remy Deomampo | 47.50 | 139.13 | 214.00 |
Rahul Dickstein | 73.50 | 505.88 | 184.00 |
Radu Donahue | 117.75 | 514.75 | 208.25 |
Preston Doorey | 61.38 | 571.50 | 334.63 |
Phill Doyle | 63.38 | 558.75 | 142.00 |
Philip Druckman | 37.13 | 495.75 | 291.25 |
Philip Duncan | 74.13 | 88.00 | 125.38 |
Peter Elia | 121.25 | 573.00 | 338.38 |
Peter Erickson | 81.00 | 453.38 | 73.75 |
Peter Espinosa | 26.13 | 427.38 | 63.38 |
Peter Ferrero | 98.25 | 347.75 | 99.25 |
Perez Figueiredo | 26.13 | 315.38 | 148.13 |
Patrick Fixler | 27.88 | 548.00 | 221.13 |
Patrick Flegal | 119.13 | 185.63 | 250.25 |
Patino Forsyth | 110.38 | 93.13 | 366.13 |
Pallavi Fox | 124.50 | 552.50 | 150.13 |
Owen Franzoni | 77.88 | 462.75 | 359.25 |
Ophir Friedman | 98.88 | 170.25 | 155.50 |
Obaid Friis | 25.63 | 331.88 | 277.63 |
Noelle Fu | 47.38 | 569.63 | 273.75 |
Noel Gambino | 102.13 | 134.88 | 332.38 |
Nicole Gao | 34.50 | 608.25 | 141.00 |
Nishant Gao | 117.13 | 622.25 | 326.50 |
Nicole Garcia | 87.00 | 260.88 | 179.50 |
Negrin Gee | 93.13 | 299.38 | 117.63 |
Filtering the date range
Table Filter allows you to filter dates in your tables. Just specify the appropriate date format and filter the table by date range.
Customer | Registration Date | First Transaction | Last Transaction |
---|---|---|---|
Stephen Chan | 5/26/2015 | 7/29/2015 | 7/19/2015 |
Steven Chan | 6/5/2015 | 7/29/2015 | 8/14/2015 |
Sompop Chang | 6/16/2015 | 7/21/2015 | 7/25/2015 |
Spencer Chang | 6/23/2015 | 7/13/2015 | 8/11/2015 |
Stephanie Chang | 6/14/2015 | 7/23/2015 | 8/9/2015 |
Simond Chat | 5/18/2015 | 6/20/2015 | 8/20/2015 |
Simon Chau | 6/17/2015 | 7/19/2015 | 7/27/2015 |
Shiv Chayet | 5/4/2015 | 7/17/2015 | 7/20/2015 |
Shannon Cheesebro | 5/11/2015 | 7/4/2015 | 8/20/2015 |
Scott Chen | 5/3/2015 | 7/27/2015 | 8/2/2015 |
Se Chen | 6/21/2015 | 7/11/2015 | 7/26/2015 |
Sean Chen | 6/9/2015 | 7/21/2015 | 7/20/2015 |
Seth Chen | 5/30/2015 | 7/15/2015 | 8/12/2015 |
Sevag Chen | 5/15/2015 | 6/24/2015 | 7/20/2015 |
Scott Cheng | 6/5/2015 | 7/12/2015 | 7/29/2015 |
Satiya Cheung | 6/5/2015 | 7/25/2015 | 8/27/2015 |
Sarah Chin | 6/4/2015 | 6/29/2015 | 8/29/2015 |
Sara Chomitz | 6/13/2015 | 6/27/2015 | 8/17/2015 |
Samuel Chou | 6/30/2015 | 7/6/2015 | 8/4/2015 |
Sang Chou | 6/18/2015 | 6/28/2015 | 8/1/2015 |
Sangjo Chou | 5/14/2015 | 7/6/2015 | 8/2/2015 |
Samantha Chu | 6/3/2015 | 7/7/2015 | 8/20/2015 |
Samaneh Chua | 6/21/2015 | 6/20/2015 | 7/22/2015 |
Salas Chung | 6/6/2015 | 7/25/2015 | 8/23/2015 |
Saeed Cilento | 5/2/2015 | 7/24/2015 | 8/26/2015 |
Changing the width of the filter boxes
Please note that Table Filter allows you to alternate width of filters on the filtration pane.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Hiding the filters
Please note that Table Filter allows you to hide or show the filtration pane on the page. Click Show filter to expand the filtration pane and Hide filter to collapse it.
Last Name | First Name | Occupation | City |
---|---|---|---|
Doe | John | Developer | London |
Fry | Philip | Delivery boy | New York City |
Doe | Janet | Scientist | Tokyo |
Farnsworth | Hubert | Scientist | New York City |
Farnsworth | Cubert | Student | New York City |
Fitting table to the screen area
Please note that Table Filter allows you to automatically fit long tables to your screen area.
First Name | Last Name | Transaction amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
---|---|---|---|---|---|---|---|
Reuben | Barnett | $129.42 | Guápiles | Tunisia | Blocked | Yes | 8 |
McKenzie | Cleveland | $216.75 | Savannah | United States | Blocked | Yes | 1 |
Portia | Lang | $422.53 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 |
Eagan | Mcgee | $253.03 | Orangeville | Afghanistan | Approved | No | 2 |
Rahim | Velazquez | $454.06 | Lac-Serent | Georgia | Approved | Yes | 6 |
Roth | Hull | $142.57 | Luziânia | Sao Tome and Principe | Blocked | No | 4 |
Jack | Griffin | $146.60 | Georgia | Bahamas | Blocked | No | 4 |
Faith | Newton | $324.96 | Okigwe | Sri Lanka | Rejected | Yes | 1 |
Basia | Ray | $260.39 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 |
Leandra | Duncan | $380.33 | My | Swaziland | Rejected | No | 6 |
Cameran | Velasquez | $144.75 | Schiltigheim | Bangladesh | Rejected | Yes | 8 |
Amery | Poole | $418.48 | Zolder | Azerbaijan | Rejected | Yes | 1 |
Owen | Welch | $279.12 | Springdale | Benin | Rejected | Yes | 4 |
Germaine | Hines | $347.08 | Bellingen | Algeria | Approved | No | 6 |
Thane | Cortez | $338.56 | Penrith | Tunisia | Approved | Yes | 1 |
Sean | Delacruz | $421.67 | Vietri di Potenza | Libya | Rejected | No | 4 |
Willow | Skinner | $216.70 | Ham-sur-Sambre | Venezuela | Approved | No | 1 |
Camilla | Good | $311.10 | Saint-Hilarion | Malawi | Rejected | No | 7 |
Ingrid | Horne | $365.20 | Crato | Dominica | Approved | Yes | 4 |
Claire | Raymond | $126.99 | Wieze | Western Sahara | Blocked | Yes | 9 |
Akeem | Holder | $131.59 | Sutton | Samoa | Blocked | Yes | 7 |
Yuli | Hubbard | $107.57 | Hudson Bay | Bolivia | Rejected | No | 4 |
Gregory | Sampson | $339.91 | Stroud | Mozambique | Blocked | No | 1 |
Freya | Osborn | $198.86 | Rexton | Luxembourg | Approved | Yes | 5 |
Kylan | Dillard | $264.70 | Market Drayton | Yemen | Rejected | No | 3 |
Curran | Dickson | $360.20 | San Francisco | Saint Martin | Blocked | No | 7 |
Sylvester | Campos | $338.44 | Riparbella | Armenia | Blocked | Yes | 5 |
Hadley | Gates | $363.39 | Chelmsford | New Zealand | Rejected | Yes | 7 |
Willa | Stevens | $137.89 | Glabais | Japan | Approved | No | 2 |
Keelie | Byers | $236.10 | Cavaion Veronese | Palestine, State of | Approved | No | 3 |
Jordan | Weber | $249.33 | Shepparton | Anguilla | Blocked | Yes | 9 |
Karly | Walls | $200.81 | Charlottetown | Guatemala | Approved | Yes | 7 |
Octavius | Cervantes | $235.63 | Merksem | Dominica | Approved | Yes | 4 |
Tyrone | Alvarez | $303.65 | Thame | Iraq | Blocked | Yes | 5 |
Jolene | Howe | $321.67 | Maple Creek | Togo | Blocked | No | 3 |
Cody | Ross | $219.44 | Gent | Austria | Blocked | Yes | 6 |
Chase | Bryant | $493.65 | Moustier-sur-Sambre | Czech Republic | Approved | No | 9 |
Lynn | Cummings | $484.17 | Metairie | Liechtenstein | Approved | No | 3 |
Lars | Shaw | $170.60 | Pittsburgh | British Indian Ocean Territory | Rejected | No | 4 |
Cassidy | Porter | $142.39 | Saint-Maur-des-Fossés | Zambia | Approved | Yes | 3 |
Whilemina | Goodwin | $255.81 | Amaro | Guinea | Rejected | No | 3 |
Jordan | Mullen | $151.41 | Alajuela | Eritrea | Approved | No | 9 |
Curran | Bond | $207.97 | Wattrelos | Belize | Approved | Yes | 4 |
Shad | Shelton | $177.90 | Salt Lake City | Estonia | Rejected | No | 4 |
Eve | Hines | $113.99 | Montpellier | Netherlands | Rejected | No | 7 |
Amir | Odom | $203.43 | Manavgat | Albania | Blocked | Yes | 5 |
Evan | Coffey | $489.53 | Prince Albert | Brunei | Rejected | No | 5 |
Quynn | King | $393.43 | São Luís | Chile | Blocked | No | 9 |
Ivy | Alvarado | $198.75 | Guwahati | Cape Verde | Approved | No | 2 |
Seth | Vasquez | $333.66 | Greater Hobart | Malaysia | Blocked | No | 3 |
Guy | Cotton | $168.20 | Saint-Pierre | Denmark | Blocked | No | 4 |
Xyla | Spears | $368.74 | Jamoigne | Guernsey | Rejected | No | 2 |
Haviva | Hancock | $136.33 | Chelsea | Zimbabwe | Approved | No | 5 |
Juliet | Barlow | $326.73 | Solingen | Iran | Approved | Yes | 7 |
Kay | Cole | $158.75 | Clare | Netherlands | Approved | Yes | 2 |
Zenaida | Kirkland | $315.19 | Yellowhead County | Mongolia | Blocked | No | 4 |
Ryan | Ware | $367.76 | Tuticorin | Armenia | Rejected | Yes | 8 |
Maite | Lowe | $256.17 | Muno | Poland | Blocked | No | 1 |
Sandra | Schultz | $273.51 | Nampa | Colombia | Approved | Yes | 9 |
Karina | Horton | $443.37 | Esslingen | Taiwan | Rejected | Yes | 2 |
Lysandra | Black | $322.36 | Strombeek-Bever | Swaziland | Blocked | Yes | 8 |
Alden | Buckner | $249.18 | San Marcello Pistoiese | Hungary | Blocked | No | 1 |
Levi | Nolan | $478.53 | Chambord | Ukraine | Rejected | No | 7 |
Buckminster | Ewing | $239.77 | Haren | Argentina | Blocked | No | 1 |
Aidan | Henson | $340.93 | Valpelline | Jersey | Approved | No | 3 |
Howard | Crosby | $201.61 | Chambave | Cameroon | Blocked | No | 2 |
Ginger | Castro | $473.40 | Isle-aux-Coudres | Latvia | Approved | No | 4 |
Hyatt | Mullins | $450.40 | Oldenzaal | Slovenia | Rejected | No | 4 |
Rachel | Head | $166.15 | Bautzen | Nauru | Blocked | No | 7 |
Shoshana | Underwood | $336.12 | Parkland County | Liechtenstein | Blocked | No | 2 |
Colt | Kent | $482.74 | Jalgaon | Grenada | Approved | Yes | 3 |
Amethyst | Dunn | $313.64 | Dipignano | Western Sahara | Approved | Yes | 9 |
Plato | Duke | $229.55 | Exeter | India | Blocked | Yes | 1 |
Jared | Dale | $391.90 | Béziers | Mauritius | Approved | Yes | 3 |
Luke | Vang | $375.44 | Vorselaar | Jersey | Blocked | Yes | 1 |
Phillip | Reed | $431.70 | Chittoor | Christmas Island | Approved | Yes | 6 |
Brandon | Lowery | $213.54 | Cork | Chad | Rejected | Yes | 1 |
Rafael | Elliott | $281.05 | Little Rock | Jamaica | Approved | Yes | 4 |
Lyle | Black | $437.51 | Mold | Palau | Rejected | Yes | 6 |
Wendy | Rosa | $219.66 | Fortaleza | Egypt | Approved | No | 7 |
Priscilla | Dodson | $414.83 | Polpenazze del Garda | Christmas Island | Approved | Yes | 1 |
Quamar | Crawford | $465.99 | Treglio | Suriname | Blocked | Yes | 2 |
Shad | Flores | $442.84 | Vezirköprü | Guyana | Blocked | Yes | 6 |
Lana | Wheeler | $202.64 | St. Neots | Palau | Rejected | No | 1 |
Vanna | Farmer | $351.21 | Millport | Maldives | Approved | Yes | 9 |
Cadman | Ray | $352.24 | Cheyenne | South Sudan | Blocked | No | 7 |
Kimberley | Savage | $429.55 | Miami | Vanuatu | Approved | No | 9 |
Armand | Sears | $477.13 | Mussy-la-Ville | Saint Vincent and The Grenadines | Approved | No | 8 |
Sawyer | Vance | $492.63 | Davoli | Benin | Rejected | No | 4 |
Tanek | Lyons | $172.85 | Rocky View | Afghanistan | Approved | No | 9 |
Nayda | Hickman | $295.47 | Newcastle-upon-Tyne | Kiribati | Blocked | No | 3 |
Aileen | Waters | $202.47 | Idar-Oberstei | Slovakia | Blocked | Yes | 3 |
Forrest | Larsen | $269.64 | Gulfport | Korea, North | Blocked | Yes | 3 |
Willa | Kemp | $239.89 | Somma Lombardo | Wallis and Futuna | Approved | Yes | 2 |
Eugenia | Byrd | $466.08 | Caruaru | Northern Mariana Islands | Rejected | Yes | 8 |
Kato | Beck | $396.49 | Khanpur | Solomon Islands | Approved | Yes | 2 |
Hiding table columns
Please note that Table Filter allows you to hide columns if you have a too wide table. Select one or multiple columns to hide in the table below.
First Name | Last Name | Contact Phones | Last Transaction Date | Bank Account Number | Transaction amount | Tax Amount | Target Transaction City | Target Transaction Country | Customer Status | Suspicious Transaction Activity | Total Transaction Number |
---|---|---|---|---|---|---|---|---|---|---|---|
Reuben | Barnett | 0500 009888 | 12/14/14 | DO07819385109432271545550865 | $129.42 | $10.28 | Guápiles | Tunisia | Blocked | Yes | 8 |
McKenzie | Cleveland | 07624 785373 | 09/15/14 | CH6046131558340157475 | $216.75 | $46.19 | Savannah | United States | Blocked | Yes | 1 |
Portia | Lang | (011247) 04420 | 09/27/14 | EE967962637165872502 | $422.53 | $16.29 | Meerut | Côte D'Ivoire (Ivory Coast) | Rejected | No | 5 |
Eagan | Mcgee | 07212 430492 | 09/19/14 | MK83589588636375406 | $253.03 | $26.26 | Orangeville | Afghanistan | Approved | No | 2 |
Rahim | Velazquez | 0325 526 8440 | 12/31/14 | FO0682149824230550 | $454.06 | $27.73 | Lac-Serent | Georgia | Approved | Yes | 6 |
Roth | Hull | 0500 311844 | 10/11/14 | LU056987267796106873 | $142.57 | $14.14 | Luziânia | Sao Tome and Principe | Blocked | No | 4 |
Jack | Griffin | 07624 307488 | 09/04/14 | BA714509342088998370 | $146.60 | $34.55 | Georgia | Bahamas | Blocked | No | 4 |
Faith | Newton | 0800 1111 | 09/24/14 | LU521764205226552485 | $324.96 | $24.60 | Okigwe | Sri Lanka | Rejected | Yes | 1 |
Basia | Ray | 0346 983 8340 | 08/13/14 | TR280491289079508593611789 | $260.39 | $45.19 | Valcourt | Equatorial Guinea | Rejected | Yes | 4 |
Leandra | Duncan | 0359 889 6822 | 01/11/15 | CR0942393063075420342 | $380.33 | $34.57 | My | Swaziland | Rejected | No | 6 |