Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColorwhite
titleBGColor#f5f5f5
titleManaging Free Text Filters

Table Filter for Confluence add-on is equipped with the free text filters. You can add this filter type for any column of your table. It allows you to enter text queries for filtration of data in the selected column of your table. You can also enter the regular expressions for flexible data filtration in the column. 

  1. Switch the page to edit mode.
  2. Insert the Table Filter macro either by entering {Table Filter} or by selecting it from other macros.
  3. Copy and paste the table into the macro.
  4. Select the macro and click Edit.
  5. In the Free Text Filter Columns box, select the columns for filtration with free text filters.
  6. Save the macro.
  7. Save the page.
  8. On the filtration pane, enter the appropriate values or use regular expressions for flexible data filtration.

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

Table Filter macro uses the OR operator for table filtration. You can use the AND operator in the free text and global filters. Enter the '&' ('ampersand') between values to match two or more values in the cell at once.

The full list of regular expressions is available here.

Widget Connector
width432
urlhttps://www.youtube.com/watch?v=6j0JCKqOBTU
height243