You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 26 Next »

 

The Table Filter add-on allows to filter the data presented in tables. Data filtration can be applied to several fields at the same time. To do this you should just specify the names of the fields. The list of possible values for filtering is taken from the table itself, there is no need for you to specify them manually.

Parameters

This Confluence add-on consists of one macro {table-filter}. To process the table data you should specify as the body of macro{table-filter} the existing table, or some other macro, the results of whose work are the table.  The parameters of {table-filter} are listed in the following table:

ParameterDefaultDescription
column The columns by which the table should be filtered. While using filters by several columns simultaneously, their names should be divided by comma
userfilter 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-width150The value of this parameter specifies the width of a drop-down filter. The value of this parameter is in pixels
buttonfalseWhen the value of this parameter is 'true' the filter can be hidden/shown by clicking
hidelabelsfalseAllows to hide labels of drop-down filters and textboxes if set to 'true'
default The default values for drop-down filters and textboxes by which the table should be filtered.

Examples

Default value for filtration and regular expressions

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

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

 

 

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

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

One column for filtration by user-entered keyword

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

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

 

One column for filtration (several values)

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

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

 

Several columns for filtration

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

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

 

Changing the width of combobox in the filter

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

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 filter

Oops, it seems that you need to place a table or a macro generating a table within the Table Filter macro.

The table is being loaded. Please wait for a bit ...

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

  • No labels