«Atlassian Confluence Advanced Permission and Security Management» course released! Try it now!
Skip to end of metadata
Go to start of metadata
Managing 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. 

Adding the Free Text Filter

  1. Edit the page.
  2. Insert the Table Filter macro and paste the table within the macro body.
  3. Select the macro and click Edit.
  4. In the Free text filter columns box, select the columns for filtration with free text filters.

  5. Save the macro.

  6. Save the page.

 

 

Filtering the table with free text filters

  1. Open the page with the table for filtration.
  2. On the filtration pane, locate the free text filters and position the mouse pointer within the appropriate one.
  3. Enter the appropriate query or regular expression for filtration.

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

 

 

Using regular expressions

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

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.

Free text filters allow you to use regular expressions while filtering table data. They allow you to write powerful filtration queries.

Quick Recipes with Regular Expressions

Regular ExpressionExplanationExample
\d\.\dThis query will look for two digits separated by the point (for example, '8.1', '9.5'). Entries with more than one digit after the point will be also included.

If applying the '\d\.\d' query to the Operating System column, you will get three values with 'OSx 5.7', 'cOS 7.2' and 'aOS 2.8' after filtration.

UserOperating System
MikeOSx 5.7
JaneSuperOS
StewartOSx 9
Jane

cOS 7.2

AndyaOS 2.8
\d\d\:\d\d\:You can use this query if you want to filter dates having time and dates without time.

If applying the '\d\d\:\d\d\:' query to the Sync Time column, you will get three values with '11/17/2015 10:35:58', '11/17/2015 12:24:54' and '11/19/2015 16:47:22' after filtration.

UserSync Time
Mike11/17/2015 10:35:58
Jane11/28/2015
Stewart11/17/2015 12:24:54
Jane11/30/2015
Molly11/16/2015 17:28
Andy11/19/2015 16:47:22

^[0-9]{2}$

^[0-9]{3}$

You can use these queries if you want to filter people by age depending on the number of digits.

If applying the '^[0-9]{2}$' query to the Age column, you will get three numbers comprised of two digits.

UserAge
Mike120
Jane75
Stewart57
Jane111
Molly85

\b([1-1][1-1])

\b([1-1][2-2])

\b([1-1][3-3])

and so on

You can use this query if you have a list with timestamps and you would like to see how many operations were performed at a particular hour,

If applying the '\b([1-1][1-1])' query to the Login time column, you will get three entries of login attempts.

UserLogin Time
Mike11:30:25
Jane13:31:25
Stewart11:32:25
Jane12:40:25
Molly11:47:25
Stewart12:20:25
h(n|a)sYou can use this query if you want to filter last names having either 'n' or 'a' between h and s.

If applying the 'h(n|a)s' query to the Last Name column, you will get four entries (Johns, Johnston, Johnson and Johason).

First NameLast Name
AlexanderJohns

John

Johnston
MikeJohney
AliceJohnson

Pavel

Johason
JaneJohannesen
JannetJohndrow
PaulJohnting
Ruby & Python

You can use '&' (ampersand) to filter cells consisting two or more values standing in different positions in the cells.

This is a custom enhancement in the add-on that simplifies the usage of the regular expression to filter cells containing two or more values at a time.

If applying the 'Ruby & Python' query to the Skills column, you will get two names of employees who have these skills.

UserSkills
MikeJava, JavaScript, HTML5, CSS, ASP, Agile
JaneJava, PHP, CSS, HTML5, Agile, Ruby
StewartSOAP, JSON, PHP, CSS, Java, REST, C++
JaneJava, Ruby, Python, PHP, CSS, HTML5
MollyPHP, CSS, Java, JavaScript, HTML5
StewartRuby, HTML5, PHP, CSS, JavaScript, Python
  • No labels