Users can now search for some specific data with regular expressions in the tables generated with the Advanced Tables for Confluence 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 the 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 enable this feature, users must toggle on the Display data filter option from the macro's Table settings.
Select this macro
| Macro name | CSV |
|---|---|
| Macro syntax | {csv} |
Define these parameters/value
| Table settings > Advanced settings > Display data filter | On |
|---|---|
| Column settings > Numbering & totaling > Insert auto number column | On |
For this example, data is fetched from a CSV attachment into the macro.
Screenshots
Example results
Usage:
Display rows that contain ja or ma: | Display rows that contain 0.: | Display rows with values in the range of 40 to 45: |
