Skip to end of banner
Go to start of banner

Filtering table data - 8.x

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

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 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 filterOn
Column settings > Numbering & totaling > Insert auto number columnOn

Screenshots

Screenshot

For this example, the data, shown in the macro, is taken from the Monthly temperatures page.

Examples

The following table lists certain sample requirements, filters applied, and the resultant data:

RequirementFilter appliedResult
Display temperatures for the months of January, March, and Mayja|ma
Display data with temperatures in the 60s60

Display data with temperatures in the range of 40 to 45 degrees4[0-5]
Display the temperatures for the last quarter of the yearber

  • No labels