Page tree
Skip to end of metadata
Go to start of metadata

Adding filters to table columns


Adding filters in the page view mode

  1. Insert the Table Filter macro.
  2. On the filtration pane in the page view mode, locate the cogwheel icon and click it.
  3. Select Add filter.
  4. Select the appropriate column and filter type (read about the filter types available below).
  5. Click Add filter.
  6. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

If adding the number or date filters, additional configuration of the data format may be required.

If you add filters to multiple columns, you may need to apply either all or separated filtration criteria. You can set the Multi-filter operation option.

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate the Multi-Filter operator box.
  5. Select the appropriate operator - AND or OR.
  6. Save the macro and the page.

If needed to filter and edit the table on the go, switch to the page edit mode, select the macro and click Show filter. All the options of the filtration pane are available in the page edit mode in Server and Data Center versions of the app.




Removing filters in the page view mode

  1. On the filtration pane, locate the filter you want to delete.
  2. Click and drag the filter to the bottom of the page. It is highlighted red.
  3. Release the left mouse button. The filter will be deleted.
  4. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

If needed to filter and edit the table on the go, switch to the page edit mode, select the macro and click Show filter. All the options of the filtration pane are available in the page edit mode in Server and Data Center versions of the app.

Look at this section if you want to remove the whole Table Filter macro from the table.


Adding and removing filters in the macro browser

To add filters to the table:

  1. Switch the page to the edit mode.
  2. Insert the Table Filter macro and paste the table within the macro body.
  3. Select the macro and click Edit.
  4. In the appropriate filter type box, select the columns for filtration with the filter type chosen. You can select multiple columns in one filter type box.

  5. Save the macro and the page.

To remove filters from the columns click the cross sign on the column label in the filter type box.

Selecting values to filter


Selecting values

In the page view mode:

  1. After adding filters to a table, locate the filter you want to specify default values for.
  2. Select or enter the appropriate default values in filter boxes for one or multiple filters.
  3. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

If needed to filter and edit the table on the go, switch to the page edit mode, select the macro and click Show filter. All the options of the filtration pane are available in the page edit mode in Server and Data Center versions of the app.

In the macro browser:

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Click Set filters' default values.
  5. Select or enter the appropriate default values for available filters. You can set multiple values for the dropdown, free text, and global filters.
  6. Save the macro and the page.

Filtering rows not equal to selected values

In the page view mode:

  1. Click the = icon for the appropriate filter on the filtration pane. The icon changes to , which means that the filter operates in the reverse mode. 
  2. Click the  icon to switch the filter back to the direct mode.
  3. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

If needed to filter and edit the table on the go, switch to the page edit mode, select the macro and click Show filter. All the options of the filtration pane are available in the page edit mode in Server and Data Center versions of the app.

In the macro browser:

  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Click Select reversed filters.
  5. Select one or multiple filters to operate in the reverse mode.
  6. Save the macro and the page.

Resetting values

The app allows you to temporarily reset the defined filtration values. This may be useful when you deal with the table with multiple filters applied. Instead of clearing values for each filter, you can do this at once.

To reset filtration values:

  1. Open the page with the table.
  2. On the filtration pane, locate and click the Reset all filters  icon.
  3. To save the modifications in the macro body, click the cogwheel icon and select Save changes.

All values in the filters are reset. If the changes are not saved, the default filtration values will be restored upon the page reload.

If needed to filter and edit the table on the go, switch to the page edit mode, select the macro and click Show filter. All the options of the filtration pane are available in the page edit mode in Server and Data Center versions of the app.

Filter types available


Dropdown Filter

Displays the list of unique values stored in the selected column of your table. You can select one or multiple values for data filtration in this dropdown filter. 

  • To filter delimited values with the Dropdown filter set the Cell value delimiter option:
  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate the Cell Value Delimiter box.
  5. Enter the character (multiple characters) used to separate values in cells. (info)
  6. Save the macro and the page.

  • To choose the way of dropdown list displaying set the Dropdown filters options updating option.
  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Select the Update dropdown filter options checkbox to display only the unique values from the selected column available after other filters were applied.
  5. Clear the Update dropdown filter options checkbox to display all the unique values from the selected column of the table. (info)
  6. Save the macro and the page.

  • You can also filter tables with @-user mentions by the current user (write or select @currentUser).

Free Text Filter

Allows you to enter text queries for filtration of data in the selected column of your table.


Global Filter

Allows you to enter text queries for simultaneous filtration of data throughout your Confluence table.


Number Range Filter

Allows you to specify the number range for showing data in the table. Alternatively, you can set the start or end value instead of the number range. Both cardinals and decimals are supported.

  • To filter the values containing the decimal places set the Decimal separator.
  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate the Decimal separator box.
  5. Select the correct decimal separator from the list, as follows:
    • Point
    • Comma
  6. Save the macro and the page.
  • To filter the table with JIRA worklogs or time intervals with the Number range filter set the Worklog settings.


Date Range Filter

Allows you to specify the date range for showing data in the table. Alternatively, you can set the start or end value instead of the number range. You can either select the date format from the pre-defined ones or manually specify the required date format.

  • To filter data with the Date range filter set the correct Date format. When the dates are inserted with help of the date picker "//" , the Table Filter macro defines the date format in the table automatically.

Visual Filter

Allows you to filter your table by one or multiple icons, emoticons, images or checked / unchecked boxes.



Hide Columns

Allows you to hide unnecessary table columns.

  • To hide columns in the page view mode:
  1. On the filtration pane in the page view mode, locate the cogwheel icon and click it.
  2. Select Add filter.
  3. Select Hide columns from the Filter types list.
  4. Click Add filter.
  5. Locate the Hide columns filter box and select the columns you want to hide.
  6. To save the modifications in the macro body, click the cogwheel icon and select Save changes.
  • To hide columns in the page edit mode:
  1. Switch the page to the edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filters tab.
  4. Select the Hide columns option.
  5. Switch to the Filtration tab and select the columns you want to hide in the Set filters' default values option.
  6. Save the macro and the page.


Watch the videos to learn more about managing filters in the page view mode and in the macro browser:

  • No labels