Versions Compared

Old Version 11

changes.mady.by.user Smita Nair

Saved on

compared with

New Version 12

changes.mady.by.user Smita Nair

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Users can now search for some specific data with regular expressions (currently works with text based searches only) 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 panel appears on the top of every table inside this macrodrop-down appears under every column heading in the 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 expressionsdrop-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 the macro's Table settings. .


Info
titleImportant information:

Filters are applicable only for text based searches, and are not applicable on data in nested macros or nested tables currently.

Select this macro

Macro name

CSV

Macro syntax{csv}

Define these parameters/value

...

Table
CSV settings >
Advanced settings > Display data filterOnColumn settings > Numbering & totaling > Insert auto number columnOn

Screenshots

Image Removed

Image Removed

Screenshot

Data source > Method of locating scriptAttachment
CSV settings > Data source > SpaceCurrent space (spaceKey)
CSV settings > Data source > PageCurrent page (@self)
CSV settings > Data source > AttachmentRows-5K.csv
Table settings > Advanced settings > Display data filterOn


...

Note
  • For this example, the table data
, shown in the macro,
  • is taken from an attachment on the
Monthly temperatures page.

Image Removed

Examples

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

...

Image Removed

...

  • same page. Thus, Method of locating script, Space, Page, and Attachment field values are specified as required.
  • You must upload a CSV file to the relevant Confluence page, and toggle the Display data filter parameter for this example to work.

Macro parameters to be defined

Image Added

Image Added

Result

In this example, as per the CSV file attached, changes made to a couple of column filters results as follows:

Image Added

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.