Page tree

Versions Compared

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 Free Text FiltersDefault Filter Values

Table Filter and Charts for Confluence add-on allows you to specify default filtration values for all filter types. You can use default values to show the required data set to your colleagues and partners. You can set filters while editing the Confluence page or viewing it.


Widget Connector
width432
urlhttps://www.youtube.com/watch?v=TtVVGEhAcJk&list=PLRpx9wuFqlzFa9X4DWwQEBdy22YIwT6kh&index=7
height243



Setting default values

  1. Switch the page to edit mode.
  2. Select the macro and click Edit.
  3. In the Free Text Filter Columns box, select the columns for filtration with free text filters.
    Image Removed
  4. Save the macro.
  5. Save the page.
  6. On the filtration pane, enter the appropriate values or use regular expressions for flexible data filtration.
    Image Removed

Using regular expressions

You can use JavaScript-style regular expressions in free text filters. 

Examples

Regular ExpressionMatched Values
[Dd]oeDoe, doe
colo(u)?rcolor, colour
Developer|ScientistDeveloper, Scientist

The full list of regular expressions is available here.

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

You can also set default values while filtering the table in the page view mode.


Image Added

Widget Connectorurlhttps://www.youtube.com/watch?v=TtVVGEhAcJk&list=PLRpx9wuFqlzFa9X4DWwQEBdy22YIwT6kh&index=7