«Advanced Permission and Security Management in Atlassian Confluence» course released! Try it now!
Skip to end of metadata
Go to start of metadata

Table Filter is one of the three macros bundled in Table Filter and Charts for Confluence add-on. This macro allows you to filter your table data with the following filter types:

  • Drop-down filter fetches all the unique values from the selected table column and allows you to select one or multiple values to filter your table by.
  • Free text filter allows you to enter custom text query to filter data in the selected column. This filter support regular expression so you can enter custom text queries for flexible data filtration.
  • Global filter works the same way as free text filter but it filters data throughout the whole table.
  • Number range filter allows you to specify the number ranges for filtering data values within the pre-defined range.
  • Date filter allows you to select the time period for showing data values.
  • Visual filter allows you to select the appropriate icons, emoticons, images or state of check boxes for filtration.

Inserting Table Filter macro on the page

There exist three ways to insert the Table Filter macro on the page.

Macro InsertionInstructionsSupported Data

Inserting the macro in the page view mode

You can disable the inline macro insertion on a global or individual basis.

  1. Open a page with a table.
  2. Hove over the table.
  3. Click the Filter table data icon on the panel that appears to the right side of the table.

This option is available in Confluence Server only.

  1. Manually created and copied tables
  2. Macros outputting table data
Inserting the macro through the action icon on the editor pane
  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer within the table.
  3. On the editor pane, click the Filter table data icon.

This option is available in Confluence Server only.

  1.  Manually created and copied tables
Manual entry of the {Table Filter} query on the page
  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer in the appropriate place on the page.
  3. Start entering {Table Filter}.
  4. From the prompted list of macro choices, select Table Filter.
  1. Manually created and copied tables
  2. Macros outputting table data
Selection of the Table Filter macro in the Select Macro form
  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer in the appropriate place on the page.
  3. On the editor pane, click Insert.
  4. In the Select Macro form, locate the Table Filter macro and insert it on the page.
  5. Place the table within the macro.
  1. Manually created and copied tables
  2. Macros outputting table data

 

 

Removing Table Filter macro for Tables

  1. Switch Confluence page to the edit mode.
  2. Select the Table Filter macro with the table or macro outputting the table.
  3. Click Unwrap.

This option is available in Confluence Server only.

 

 

Copying a table into Table Filter macro

  1. Switch Confluence page to the edit mode.
  2. Position the mouse pointer into any cell of the table you want to copy.
  3. Click the Copy Table icon on the editor pane.
  4. Paste the table into the Table Filter macro on the same or on a new page.

This option is available in Confluence Server only.

  • No labels