Table Filter for Confluence add-on allows you to set the number of table rows to show, enable static or dynamic row numbering and apply the default sorting order to each table column. Additionally, you can regulate width of filter boxes, enable fitting the table to the allocated screen area or enable hiding the filtration pane. 

Applying the default sorting order to columns

Starting from version 3.1.0 Table Filter add-on allows you to apply default sorting order to values in multiple columns.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Locate the Default Sorting box.
  4. Click it and select the columns with the appropriate sorting order in them. Once you have saved the macro and the page, the defined sorting order is automatically applied to the selected columns.

Adding automatic row numbering

You can enable automatic row numbering if you have a large data table.You can choose among the following options:

  • Dynamic Ascending
  • Dynamic Descending
  • Static Ascending
  • Static Descending
  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Locate the Automatic Row Numbering box and select the appropriate row numbering option.

Hiding table columns

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Select the Hide columns option.
  4. Click the Filters' Default Values button.
  5. Locate the Hide columns box and select the columns you want to hide.
  6. Click Save.
  7. Save the macro and page.

Changing order of filters

You can change order of filters of the same type. Order of filters of different types cannot be changed.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Locate the filter type in which you want to change order of filtered columns
  4. Drag the column label to the appropriate place in the filter box.

Fitting the table to screen area

This functionality is not available for Confluence Cloud version.

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Select the Fit Table to Screen Area option.
  4. Save the macro and page.

Once you save the page, the table will automatically fit the screen area.

Hiding filter labels

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Select the Hide Filter Labels option.
  4. Save the macro and page.

 

Hiding the filtration pane 

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Select the Hide Filters by Default option.
  4. Save the macro and page.

Setting default width for filter boxes

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Click Set Width of filters.
  4. Enter the appropriate width in pixels for filters.
  5. Save the macro and page.

Disabling / Enabling filters

  1. Open the page with Table Filter macro.
  2. On the filtration pane, locate and click the Disable all filters  icon.
  3. On the filtration pane, locate and click the Enable all filters  icon.