Filter table data - 11.x

Users can now perform simple text-based searches or complex searches that use regular expressions in the tables generated with the SQL for Confluence macros. If the Display data filter option is enabled in the macro's editor, a filter panel appears on the top of every table. 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 an SQL Query macro.

To enable this feature, users must enable the Display data filter option from the macro's Table settings.

Select this macro

Macro name	SQL Query
Macro syntax	{sql-query}

Define these parameters/value

Table settings > Advanced settings > Display data filter	On

Parameter to be set in the macro editor

Screenshot

Examples

The following table lists certain sample requirements, filters applied, and the resulting 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