Users can now search for some specific data (currently works with text based searches which may contain some special characters) with column filters 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 drop-down appears under every column heading in the table. This panel contains a drop-down list that contains all unique values per column. By default, the None option is selected, and thus, all the column values are displayed in the drop-down list. Note that for every value selected for a column the entire table data display changes as per the selection.
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.
Note |
---|
To enable this feature, users must toggle on the Display data filter option from any of the macro's Table settings. |
Info | ||
---|---|---|
| ||
|
Select this macro
Macro name | CSV |
---|---|
Macro syntax | {csv} |
Define these parameters/value
CSV settings > Data source > Method of locating script | Attachment |
---|---|
CSV settings > Data source > Space | Current space (spaceKey) |
CSV settings > Data source > Page | Current page (@self) |
CSV settings > Data source > Attachment | Rows-5K.csv |
Table settings > Advanced settings > Display data filter | On |
Note |
---|
|
...
Screenshots
Example results
Usage:
...
|
Macro parameters to be defined
Result
In this example, as per the CSV file attached, changes made to a couple of column filters results as follows:
Info |
---|
There is a known issue with the Display data filter parameter. When you select the drop-down for the first time, the column gets sorted though the list is not visible, and from the next click onwards, the list drops down displaying the unique values available in that column. |