Katerina Kovriga {Stiltsoft} Expert

Hi @Juels Vaughn , You may use the Handy Macros for Confluence app. Its Handy Status macro allows you to create pre-defined sets of statuses or options, use them inside your tables and switch them easily in the page view mode.

Hi, please, check again your SQL query (you should compare every column with "today" separately) and the date format in the Table Transformer macro (Settings -> Date format, it should correspond the date format inside your original table). To find a mistake, we need to see screenshots of your original table and the…

Hi @Suresh Venkat , you may try the Table Filter and Charts for Confluence app. Its Table Excerpt/Table Excerpt Include macros collect multiple-row tables from a current page, specific page, page and childpages, page and all descendants, pages with specific labels. So, you'll be able to combine all your mini-tables on the…

Hi @Arnaud de Loitière , you may try the Table Filter and Charts for Confluence app. Its Table Excerpt/Table Excerpt Include macros collect multiple-row tables from a current page, specific page, page and childpages, page and all descendants, pages with specific labels. Here is our recent blog post related to your case…

The Table Filter macro can be used in a hidden state - you are able to filter, for example, the Red status, save the filter and hide the filtering panel from other users. So your colleagues will see only specific rows that were predefined by you. Additional filtering icons won't be visible in the page view mode at all. But…

I'm not sure of user macros, but in my reply I didn't mean for you to show the plain list of issues. Step 1 is really to use the Jira Issues macro for each of your projects. Here you use the JQL project = project_name. As a result, you get the following picture: And, of course, you may choose to show any fields you need in…

Hi @Bobby Boruah , At the moment Confluence doesn't support table filtering, so you'll need to use additional apps to implement the case. For example, you may try the Table Filter and Charts for Confluence app and its Table Filter macro: If you keep your dates in a separate column, you may use the Date Range filter. But…

Hi @Brylie Christopher Oxley , You may use the Table Filter and Charts for Confluence app. Use the Table Toolbox macro to wrap your source table in the Pivot Table and Chart from Table macro and get the required result: Here I've chosen to hide the source table for the screenshots to look more clear, but you may tick the…

Hi @정영환 , You've found the right answer with the Table Filter and Charts for Confluence app. What concerns your worries about the source table, the Pivot macro allows you to hide it (as was shown into the previous question). If you need to show the source table along with your pivot, just tick the corresponding field in…

Hi @David Doria , here is our latest update for the Table Excerpt/Table Excerpt Include macros: now you can show page titles of included tables automatically. Just tick the Show page titles of included tables field and you'll see the links to the pages with Excerpt macros:

Hi @Francis Atienza , here is our latest update for the Table Excerpt/Table Excerpt Include macros: now you can show page titles of included tables automatically. Just tick the Show page titles of included tables field and you'll see the links to the pages with Excerpt macros:

Hi @Soumalya Sen , You should try the standard Jira Issues macro. You'll be able to collect Jira Issues on your Confluence pages and specify which issue fields you want to show: To aggregate your issues by fix versions and sprints, you need to use additional apps, for example, Table Filter and Charts for Confluence. Maybe…

Hi @Dolev Sall, Check this thread in the Community. The second part of the discussion is related to your case - how to add an additional column with comments to your Jira Issues macro in Confluence Cloud.

Sorry, couldn't come with any ideas. Our Table Transformer allows to split one column into two (for example, if you need to divide task name and its description) and you'll be able to merge several columns into one (not specific cells but the whole columns of a native Confluence table or created with the Table from CSV…

Hi @Chetan Belur , Unfortunately, you won't be able to implement the case. Due to the limitations of Confluence editor, the Table Transformer macro transforms multi-level headings to one-level headings so that to accomplish further operations with columns.

You may check this thread where I describe how to merge data from manually created table and the Jira Issues macro https://community.atlassian.com/t5/Confluence-questions/Can-I-dynamically-populate-the-fields-of-a-table-based-on-values/qaq-p/1505810 The only difference for your Cloud instance will be that you need to use…

And where do you collect you information from? The FixVersion comes from the Jira Issues macro? Or there is another manually created table in Confluence with Project/FixVersion information? And you need to reuse that source table and manually add an assignee column or smth?

Hi, sorry, didn't get the question - do you use the Jira Issues macro wrapped in one of the Table Filter and Charts' macros and need to show the FixVersion column? Then you need to go to the Jira Issues macro settings and choose what columns you need to display: And the Code Snippet macro is a substitute for the old Code…

@政 蔡, you could really use the Table Filter macro from the Table Filter and Charts for Confluence app that you were recommended in the previous answer to freeze rows and columns. Go to the macro settings -> Table View tab -> Freeze first N rows/Freeze first N columns fields and type in the required number:

Hi @[deleted] , check this blog post - it describes (with a screenshot attached) how to copy tables in Confluence Cloud. You may also get some other useful tips about working with tables from the article. Step 1 - Select the whole table Step 2 - Press Ctrl+C

To work with the cells background, you need to update the app (FORMATWIKI was added in October, 2020). The IF THEN query adds an additional column based on the second mini table inside the Table Transformer macro. It seems that you are referring to this case. But you can't work with the cells background and text color…

Hi @Kelly Hall , what do you mean by the phrase that formatwiki is not available for your company? If you have our app with the Table Transformer macro, then the macro will understand formatwiki markup. If the Table Transformer doesn't recognize these commands, it means that you use an old version of the app and you need…

Hi, we can also recommend our Table Filter and Charts for Confluence app to create Jira dashboards in Confluence. Wrap your Jira Issues macro in the Table Toolbox macro for Cloud instances and use Pivot and Chart from Table macros to aggregate and visualize your data. You may see more examples of Jira dashboards here.

Hi @Wesley Aldridge , You may use the Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros that can help you to reuse your Confluence tables so that you'll need to update only the source table. You may also check our recent blog post where we show step-by-step how to aggregate and…

For the first question: you should apply conditional formatting separately for every required column ('Jake', 'Kev' and 'Dave'). You compare every column date with "today" so you can't list several columns at once via commas. SELECT *, FORMATWIKI("{cell:bgColor=" + CASE WHEN DATEDIFF(day,"today",'Jake') <= "0" THEN…

If you want all the columns from your table to be displayed, than use an asterisk: SELECT *, FORMATWIKI ... If you want to show only specific columns, than list them: SELECT T1.'Certification', T1.'Jake' ... In the end of your SQL query you can type T1 or T* - it makes no difference because you have only one table inside…

If you have the Table Filter and Charts for Confluence app installed for your instance, you may try the Table Transformer macro and its changing column width feature. Here is an example with screenshots - just wrap your table in the Table Transformer macro and type in a custom SQL query.

Hi @Pansilu Diegayu Wickramasinghe , You may try the Table Filter and Charts for Confluence app and its Table Transformer macro with the advanced cells formatting feature. Wrap your table in the Table Transformer macro: Set an appropriate date format: And use the following custom SQL query to count the period between two…

Hi, you may try the standard Attachments macro.

Hi @Fulbert Lato , You may try the following SQL query: SELECT *, FORMATDATE(DATEADD(day, T1.'Period' + 2 * FLOOR(T1.'Period' / 5) + CASE WHEN 'Start Date'::Date->getDay() = 0 THEN 1 WHEN 'Start Date'::Date->getDay() = 6 THEN 2 WHEN ('Start Date'::Date->getDay()) + T1.'Period' % 5 > 5 THEN 2 ELSE 0 END, T1.'Start Date'))…