Table Filter and Charts for Confluence add-on allows you to filter your table data while you are editing it on the page. You can manage all the necessary filters while working with table data and filter it on the fly.
Starting from version 3.3.0 Table Filter and Charts for Confluence add-on supports filtration of table in the page view mode. It can be very convenient when you need to add modifications into multiple rows having one or multiple similar parameters.
This functionality is not available for Confluence Cloud.
For resolving the issue with the collaborative editing available since Confluence 6.0, please see our FAQ.
Adding Filters
You can add filters in two ways:
- Standard - you can edit the macro settings as in old versions of the add-on.
- On-the-fly - you can add filters as you get used to adding them in the page view mode.
All the filters saved in the macro body will be available for data filtration in the page edit mode.
- Click the first line in the macro body or click the macro body.
- Click Show filter. The filtration pane will be embedded into the editor panel.
- On the appeared pane, click the cogwheel icon.
- Select the appropriate filter type and the column for filtration. The process of adding filters is quite similar to adding filters in the page view mode.
- Click Add filter.
- To save the filter or filters, click the cogwheel icon.
- Click Save changes.
All the filters added for table filtration in the page edit mode will be preserved in the page view once you save them through the filtration pane.
When adding the Date Range Filter, you will have to edit the macro settings as usual and specify the correct date format.
Filtering Table Data
- Select or specify the required values in the added filters. Your table will be filtered and only the matching values will remain.
To save the selected or specified values as defaults, click the Save settings
icon. - To reset the specified filter values, click the Reset all filters
icon.
Once you have applied some filters to your table data, you may need to add new rows or correct the existing data.
All the made corrections or newly added rows will be preserved in the table if they match the defined filters. If they do not match the defined filters, they will be preserved in the table until you perform any action on the table through the native table management pane.
Optimizing Work with Table Data
Table Filter macro allows you to more efficiently work with table data with the following options:
- sorting table one or multiple columns while holding the Ctrl key or Ctrl + Shift keys correspondingly
- fitting a long table to the available screen area
- enabling automatic row numbering
For the details on how to activate these options, see Managing Look of the Table and Filtration Pane.
All these options are available while working with the table data in the page edit mode.