Table filtration

Read more:

• Sorting, freezing and other table viewing options
• Calculations in tables
• Configuring the filtration pane

Quick inline filtration in the page view mode 

1. Hover over a column header.
2. Click the Funnel icon.
3. Select or type values to filter table data.
4. Add multiple filters to table columns.
5. Use all the options available in the classic filtration panel: filtering the whole table, hiding columns, filtering not equal values, exporting table data.
6. To save the changes and insert the Table Filter macro click the funnel icon in the top right corner and select Save changes.

In Cloud you need to enable table filtration on a page first.

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 Settings tab.
4. Locate the Multi-Filter operator box.
5. Select the appropriate operator - AND or OR.
6. Save the macro and the page.

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 out of the filtration panel's range. 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.
   
   

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 Filters tab, click the Add filter button and select the column for filtration along with the filter type. You can select same columns to set different filters.

5. Save the macro and the page.

To remove filters from the columns click the urn icon to the right of 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.

In the macro browser:

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Filters tab.
4. Select or enter the appropriate default values for available filters. You can set multiple values for the dropdown, free text, and global filters.
5. 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.

In the macro browser:

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Switch to the Filters tab.
4. Click the = icon of the appropriate filter(s) set for the chosen column(s). The icon changes to ≠, which means that the filter operates in the reverse mode. Click the ≠ icon again to switch back to the direct mode.
5. 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, click the cogwheel icon and select the Reset all filters .
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.

Ignoring top rows when filtering

Set this option if you have some data in the top rows of a table that you don't want to be filtered.

1. Switch the page to the edit mode.
2. Select the macro and click Edit.
3. Select the Settings tab.
4. Locate the Ignore First N rows option.
5. Enter the number of table rows to display.
6. Save the macro and page.

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 delimiters option:

1. Switch the page to edit mode.

2. Select the macro and click Edit.

3. Switch to the Filter tab.

4. Locate the appropriate column with the selected Dropdown filter and click the cogwheel icon to the right.

5. Locate the Cell value delimiter field.

6. Enter the character (multiple characters) used to separate values in cells. 

7. Save the macro and the page.

<div class="handy-tip-dialog wiki-content"> <p>If the cell value delimiter is not a regular character, but the space, use the Unicode character <span> <strong>\u0020</strong>.</span></p> </div>

To filter all selected values, choose OR operator in the Set dropdown filter operators option.

• 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 Settings tab.

4. Click the Update dropdown filter options slider to display only the unique values from the selected column available after other filters were applied.

5. Click the Update dropdown filter options slider again to display all the unique values from the selected column of the table.

6. Save the macro and the page.

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

• To filter tables by the current page title, enter  @pageTitle in the dropdown filter.

Free Text Filter

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

• For more complex text filtration use regular expressions.
• To filter tables by the current page title, enter  @pageTitle in the free text filter.

Global Filter

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

• For more complex text filtration use regular expressions.

Number 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 Сalculations tab.
4. Locate the Decimal separator field.
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 date range. You can either select the date format from the pre-defined ones or manually specify the required date format.

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

• To filter by the dynamic date ranges set the dynamic values in the Date range filter's input . The filtered results will automatically update according to today's date .

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. Click Add filter.
5. Select the Hide columns in the filter types and choose the columns you want to hide.
6. Save the macro and the page.