1. What can I do if I can't find and add the macros?
Make sure the Table Filter and Charts for Confluence is installed in your Confluence instance. The app is not built-in. Install Table Filter and Charts for Confluence from the Atlassian Marketplace.
2. How do I install this app?
3. How can I remove the macro accidentally added to a table?
4. Is the app compatible with the Jira Issues macro?
Yes, the app is compatible with the built-in Confluence macros and the third-party apps, that output the table data, including the Jira Issues macro. Look at the example here.
5. Can I use the app for a table with merged cells?
Yes, you can.
6. Can I filter an already existing table?
7. Can I use the macros with tables generated by another macro?
8. How can I export an unfiltered table to PDF/Word?
- Click the Disable all filters icon. For details, see the how to disable filters section.
- From the Tools menu, select Export to PDF or Export to Word.
9. Can I filter only empty values in the table?
Yes, you can. In the filter box for the appropriate column, select '-Empty-'. The app will output only the empty cells.
10. How can I filter not equal values in the table?
You can use the reversed filtration option to filter not equal values.
11. How can I freeze rows and/or columns of the table?
You can use the Freeze first N rows or columns options.
12. How can I sort the table in the edit page mode?
You need to wrap the table with Table Filter, hover over the table header, press CRTL on the keyboard, and click it.
13. What are the supported date formats?
You can specify the date format as a string value. Read this article for details.
14. Why do macros process my worklog values incorrectly?
You may encounter problems with the processing of worklog values when you are using languages different from English. You need to configure the worklog settings and set the appropriate shortenings for time units.
15. Why do the macros process the tables generated by the Jira Issues / Page Properties Report / Task Report macros partially?
The Table Filter, Pivot Table, Chart from Table, Table Transformer macros work only with the rows currently displayed on a page. They can't influence or make changes (such as collecting not displayed data) to the built-in (Jira Issues, Task Report, Page Properties Report) and third-party macros.
To filter more values within one page you need to increase the number of rows per page to display.
16. How can I insert macros with the body (Table Filter, Pivot Table, Table Transformer, Chart from Table) into each other in Confluence Cloud?
You can combine them with the help of the Table Toolbox macro in Confluence Cloud.
17. Why does "Error: Column does not exist:" appear in Table Transformer using several Table Excerpt Include macros in it?
The reason for this error is usually in the incorrect order of Table Excerpts on the page as Table Excerpt Include macros work as references to them.
And the number of the included tables (T1, T2, etc.) is an ordinal number of your tables within a page in the page view mode.
To resolve the issue, please rearrange Table Excerpts on the page or change the order of Table Excerpt Include macros within the Table Transformer macro and rewrite SQL query accordingly.
18. Why can a user see restricted data on the page using the Confluence Server mobile app or the Confluence mobile site?
After changing page permissions for a user, viewing the restricted data is still possible until this user or another with the same restrictions revisit the page.
The reason for this is that the user has already viewed or exported restricted data on the page earlier.
19. What happens with tables wrapped in the macros after the purchased license expiration?
Cloud/Data Center versions:
After the end of the paid subscription, the macros bundled in the Table Filter and Charts for Confluence app become unavailable.
However, your table data is not missed. You need to copy-paste tables outside the macro bodies and then remove the macros.
When a commercial license is expired, you can continue using the app. Your table data is also not missed.
But there is no ability to update the app to the latest versions.