How to apply filters on table data - Cloud
Users can now search for some specific data with regular expressions in the tables generated with the Advanced Tables for Confluence Cloud macros. If the Display data filter option is toggled on in the macro's settings, a filter panel appears on the top of every table inside this macro. This panel contains a text box to enter the required search criteria and buttons: Filter to apply the search against the data rows, and, Clear to clear the box to start a new search. Refer to this article to know more about regular expressions.
This page provides an example of how to use filters. Though you can use this feature with any of the macros, for this example, let's work with a CSV macro.
To use this feature, users must enable the Display data filter option from the macro editor.
Select this macro
Macro name | CSV |
|---|---|
Macro syntax (Old editor) | {csv} |
Macro syntax (New editor - case insensitive) | /CSV (Comma Separated Values) |
Define these parameters/value
Display data filter | On |
|---|
Parameters set in the macro editor
For this example, the data from the Monthly temperatures page was entered as a comma separated value list in the macro body itself.
Example result
Sample filters applied to the table
The following table lists certain sample requirements, filters applied, and the resultant data:
Requirement | Filter applied | Result |
|---|---|---|
Display temperatures for the months of January, March, and May | ja|ma | |
Display data with temperatures in the 60s | 60 | |
Display data with temperatures in the range of 40 to 45 degrees | 4[0-5] | |
Display the temperatures for the last quarter of the year | ber | |