Katerina Kovriga {Stiltsoft} Expert

Hi @Jens Gerlach , Check if you have the Table Filter and Charts for Confluence app installed for your instance. Its Table Filter macro allows you to use the freezing first N rows feature, it works with the Page Properties Report macro perfectly well.

Hi @Etienne Basson , you'll need additional apps to enhance the standard Content Report Table macro. For example, you may use the Table Filter and Charts for Confluence app and its Table Filter macro. Wrap your Content Report Table macro into the Table Filter macro body and apply the default sorting to any column you want.…

Hi @Yasmin Nisyah , You may need additional apps to work with your final Page Properties Report macro and create different tables (pivots, visualized charts) to indicate different aspects of your project clearly. For example, you may try the Table Filter and Charts for Confluence app. Here are several examples how to…

Hi @Matthew Phillippi , Please, check this question - How do I calculate date plus days without weekends in Table Transformer SQL. It perfectly matches your case. The Table Transformer macro is provided by the Table Filter and Charts for Confluence app.

Hi @Gregory , you won't be able to do so with the help of standard Confluence permission tools. You can grant the permission to edit the whole page, not the specific elements like tables. But there are several workarounds: you may try to use two pages and use the standard Excerpt/Excerpt Include macros. So, your user will…

@Мизин Евгений , Search for the standard Page Properties/Page Properties Report macros in the Atlassian documentation, they may help your case.

@Мизин Евгений , Search for the templates in Confluence - pages with partly predefined content. It may help your case.

@Peter-I , check if your company uses the Table Filter and Charts for Confluence app (search for the Table Filter macro in your macro browser). We added the Table from JSON macro to the app 04.11.2020. It suits your case and supports outputting data from a URL.

Hi @Sia.Shevchenko , You may try additional apps to filter you Jira issues, for example, Table Filter and Charts for Confluence. Wrap you Jira Issues macro into the Table Filter macro and set the required filters: free text to search inside the Summary column, dropdown for assignees, global filter to search the whole…

Hi @Wesley Naidoo , if your tables are one-row ones, you may use the standard Page Properties Report macro. If you use bigger tables, than you'll need additional apps to implement your case, for example, Table Filter and Charts for Confluence. You may reuse your tables and collect them onto one page with the help of the…

Yes, it is. It works both with plain manually created tables and with Confluence macros that return data in a tabular format (Content Report Table, Page Properties Report), so you'll be able to apply sorting (filtering, pagination, etc.) to such tables as well.

Hi @preeti arun , I can suggest using the Table Filter and Charts for Confluence app. The first step is to create your big master table with all the required information. This table will be editable and every owner will update his/her name, frequency, page titles, etc. The second step is to reuse this master table onto…

@Ole Jørgen as @Andrey Khaneev _StiltSoft_ has mentioned before, wrap the Content Report Table macro into the Table Filter macro provided by the Table Filter and Charts for Confluence app and apply the required sorting. And here is a short 2-minute video tutorial how to aggregate (create pivots) and visualize your reports…

We often use CSS to hide specific items from the Table Filter menu. Here is an example of several expressions to hide the "Hide columns" option for the different variants of the macro usage. What exactly do you need to do? Do you use a filtering panel and when there are no any results you want to hide it? So your…

Hi @sa_mejia , I can suggest wrapping your Table Filter macro into the Table Transformer macro: So when you don't have any suitable rows to display, you'll get a blue info message that there are no any rows returned (not the empty table header row as you had before).

In your example I really can't see what is the difference between the two values - try to raise a support ticket for Atlassian.

Maybe I didn't get the case then - I decided that when you collect your Page Properties Report, you have columns with statuses (Status Macros) and priority (emojis). But you don't want to show all the rows, so you need to filter your table.

Hi @Marc Frei , You'll need additional apps to filter Page Properties Report tables, for example, Table Filter and Charts for Confluence. You may check here how to filter, aggregate and visualize your Page Properties Report macro.

Hi @Craig Buchanan , I've consulted the developers team and they strongly recommend to update the app to make the query work (it should work from the 6.3.8 version). The current version is 7.1.9. Besides from the 7.0.0 version you'll be able to use Smart Charts Insertion in the page view mode.

If you are interested in the Table Filter and Charts for Confluence app, you can book a live demo from our team - we'll be glad to show you the whole bunch of provided macros and their main capabilities.

Hi @Craig Buchanan , Please clarify which hosting do you use - Cloud or Server/DC (and the app version for the latter). I've checked your query both on the Cloud version and the up-to-date Server version and everything seems to work fine: I've copied your query without any changes: If you use the advanced cells formatting,…

Hi @Maren Regin , The Table Excerpt/Table Excerpt Include macros are a part of the Table Filter and Charts for Confluence app. Your Confluence administrator may provide you with the list of the add-ons installed for your instance. And you may also try to check if you have other macros from the Table Filter and Charts for…

Hi @Robert P. Ferinde , You may browse Marketplace to find some additional apps that will fulfill your case. For example, you can try our Handy Macros for Confluence app. Its Handy Status macro allows you to create predefined set of statuses and switch them (choose any status you want) in the page view mode. And the Handy…

Hi @Pansilu Diegayu Wickramasinghe , Try the following query: SELECT *, FORMATWIKI("{cell:bgColor=" + CASE WHEN T1.'Jack' IS NULL THEN "#FFFFFF" WHEN DATEDIFF(day,"today",'Jack') <= "0" THEN "#FA7E70" WHEN DATEDIFF(day,"today",'Jack') > "0" AND DATEDIFF(day,"today",'Jack') <= "180" THEN "#FFE784" ELSE "#8FCA7D" END + "}" +…

Hi @Robin Silander , Check if you have the Table Filter and Charts for Confluence app installed for your instance. If you use, for example, Pivot Table and Table Transformer macros along with the Jira Issues macro, you'll be able to aggregate your Jira data and add manually created columns with different notes and links to…

Nice to hear that our app matches your case. If you are going to start a trial period for the app, I can suggest booking a live demo. There you may ask to learn about your exact issue from our team-consultant.

Hi @Craig Buchanan , You may try the following SQL query to split your text cell by the space symbol between the quantity number and the item name: SELECT T1.'Produce'->split(" ")->0 AS 'Quantity', T1.'Produce'->split(" ")->1 AS 'Produce' FROM T*

Hi @Pansilu Diegayu Wickramasinghe , If you have empty cells in your table and want them to be white (or any other color you wish), add an additional "when" entry into your query: WHEN T1.'Jack' IS NULL THEN "#FFFFFF" Here is an example for T1.'Jack' with this additional entry and T1.'Nick' without it: SELECT *,…

We have conditional formatting supported in the Table Transformer macro - our bundle of macros is supposed to bring Excel features into Confluence. So you may wrap your CSV macro in the Table Transformer macro, list only that columns which you want to display and apply conditional formatting based on the Wiki Markup. Here…

Yep, then the screenshot of your opened CSV file (so we'll check delimiters).