(OUTDATED) Table Filter and Charts for Confluence

Space shortcuts

Page tree

Versions Compared

Old Version 1

changes.mady.by.user Vadim Rutkevich

Saved on

compared with

New Version Current

changes.mady.by.user Natalie Paramonova

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Mybanner

This version of the app's documentation is outdated. Please find the information you're looking for here:




Panel
bgColorwhite
titleBGColor#f5f5f5
titleManaging Look of Table and Filtration Pane

Table Filter and Charts for Confluence add-on allows you to manage filtration parameters and adjust them to your actual needs.

Table of Contents

 

 




Setting the Decimal Separator

You may need to set the correct decimal separator when using the number range filters or enabling sparkline charts if your table contains decimal numbers.

To set the decimal separator:

  1. Switch the page to 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.

 

 



Setting the Date Format

You may need to set the correct date format when using the date range filters. Filtration of dates may work incorrectly if the incorrect date format is specified.

To set the date format:

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate the Date format box.
  5. Select the correct date format from the list or manually specify the needed format.
  6. Save the macro and the page.

You can also define the date format in the page view mode.

Info

For the details on specifying date formats, see our FAQ.


 

 



Setting default width for filter boxes

You may need to increase or decrease of filter boxes shown on the filtration pane.

To set width for filter boxes:

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

For the details on how set width of filter boxes in the page view mode, see this.

 

 



Disabling the Change Saving

You may need to disable the saving changes after filtration. This can be useful when you share some table with other people and set the default values for filtration, and do not want them to be overwritten.

To disable the change saving:

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate and select the Disable the change saving option.
  5. Save the macro and the page.

 

 

 

 

 

 

You can copy the link to the currently used filters and applied values and further share it with your colleagues, so they can quickly open the filtered data series even when the initial filtration has been changed since then.

  1. On the filtration pane, click the cogwheel button.
  2. Select Copy the filter URL.

The link to the current filtered data series will be copied to the buffer.

Image Removed



Hiding Filter Labels

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

Image Added



Hiding the Filtration Pane

Table Filter and Charts add-on allows you to hide the filtration pane in the page view mode. This may be useful when you have applied the required filters and do not want to allow other users filter the table.

To hide the filtration pane:

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. Switch to the Filtration tab.
  4. Locate and select the Hide filtration pane option.
  5. Save the macro and the page.

To restore the filtration pane, reset selection for the Hide filtration pane option.

Image Added



Hiding the control buttons

Table Filter and Charts add-on allows you to hide the control buttons shown when you click the Cogwheel button on the filtration pane. This may be useful when you want to disable export of table date or its sharing.

To hide the control button on the filtration pane:

Hiding table columns

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  • Select the Hide columns option.
  • Click the Filters' Default Values button.
  • Locate the Hide columns box and select the columns you want to hide.
    1. Switch to the Filtration tab.
    2. Locate and select the Hide control buttons option
    Click Save
    1. .
    2. Save the macro and the page.

    To restore the filtration pane, reset selection for the Hide control buttons option.

    Image Removed

    Image Added



    Changing order of filters

    You

    While editing the macro you can change order of filters of the same type. Order of filters of different types

    cannot be changed

    can be modified in the page view mode.

    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.
    5. Save the macro and the page.

    Image Removed

    Image Added



    Setting the Data Operator

    Hiding filter labels

    1. Switch the page to edit mode.
    2. Select the macro and click Edit.

    Select the Hide Filter Labels option
    1. Switch to the Filtration tab.
    2. Locate the Multi-Filter Operator box.
    3. Select the appropriate operator - AND or OR.
    4. Save the macro and the page.

     Image Removed

    Collapsing / expanding the filtration pane 

    1. Open the page with Table Filter macro.
    2. Point to the bottom of the filtration pane.
      Image Removed
    3. Click the collapse bar.
    4. Point to the header of the table.
      Image Removed
    5. Click the expand bar.

    Image Removed

    Disabling / Enabling filters

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

    Image Added



    Setting the Cell Value Delimiter

    The cell value delimiter is used for treating multiple delimited values in table cells as separate values in the dropdown filter.

    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.
    6. Save the macro and the page.

    Image Added



    Setting worklog settings

    Excerpt


    Info

    Please ensure that the worklog parameters set in the macro are identical to parameters configured in Atlassian JIRA.


    1. Switch the page to edit mode.
    2. Select the macro and click Edit.
    3. Switch to the Filtration tab.
    4. Click the Set worklog settings button.
    5. In the opened form, define the worklog parameters, as follows:
      1. Days in week - enter the number of business days in a week.
      2. Hours in day - enter the number of working hours in one business day.
      3. Time format - select the used time format in worklog values.
      4. Week shortening - enter the shortening for the week time unit if you use any language different from English.
      5. Day shortening - enter the shortening for the day time unit if you use any language different from English.
      6. Hour shortening - enter the shortening for the hour time unit if you use any language different from English.
      7. Minute shortening - enter the shortening for the minute time unit if you use any language different from English.
    6. Click Save.
    7. Save the macro and the page.
    Info

    Worklog time units in different languages are denoted with different shortenings. Please adjust them according to your JIRA localization settings.



    Image Added