Katerina Kovriga {Stiltsoft} Expert

@Daisy Fischlein Steffensen , modify your SQL query a little bit to check both variants of the "Key" field: Previous version SELECT T1.'Key', T1.'Summary', T1.'Created', T1.'Assignee', T1.'Status', T2.'Manually Added Comment' FROM T1 JOIN T2 ON T1.'Key' = T2.'Key' New version SELECT COALESCE(T1.'Key', T1.'Nøgle') AS 'Key',…

Then maybe the Jira Issues macro will help - here is its documentation and a short video how to use it.

It seems that you use two Attachment macros for the purpose, but they collect all files from your page, they simply duplicate each other. Create a simple Confluence table and manually attach the required files into the cells using the Insert files and images button: Here I have 3 different files attached that are shown as…

Hi @Marco Schneider , Have no access to your page, but still we recommend to use additional apps to work with Excel files in Confluence. For example, our Table Filter and Charts for Confluence app provides the Table from CSV macro. The macro allows you to output a table from CSV or TSV data source and supports outputting…

Hi @Cholo Sabido , If by a "tracker" you mean that you need to collect data from multiple Confluence pages (if you create a separate page for every new feature) and want to build a summary report to track the progress, you may use the Page Properties/Page Properties Report macros. Here is a short 2-minute video tutorial…

Hi @laurent , I guess you use ConfiForms tables and want to perform calculations in such tables. Maybe our app will come in handy for your case - Table Filter and Charts for Confluence. The app works with the TableView macro perfectly well: you just wrap your TableView macro in our macros and perform various calculations,…

You may use the Table Filter and Charts for Confluence app and its Table from CSV macro. The macro allows you to output a table from CSV or TSV data source and supports outputting data from a URL (Google Sheet/Google Drive) or an attached file. All the Table from CSV macro settings are very simple and intuitive:

Hi @Michael Confessore , You may try to use the Table Filter and Charts for Confluence app that works with ConfiForms TableView macro perfectly well. Wrap your TableView macro in the Table Filter macro and choose the column that you want to hide: Hope this helps.

@Bjørn Tennøe , you may hide your additional column with the help of the Table Filter macro. Wrap your Table Transformer macro in the Table Filter macro body: And check the Hide columns box into the Filters tab: Then go to the Filtration tab -> Set filters' default values section and choose what columns you want to hide:…

Hi @Leead Durban , If you have the Table Filter and Charts for Confluence app installed for your instance, its Table Transformer macro may help your case. Wrap your table in the macro and set the required column width using the Wiki Markup: Here is an example of your custom SQL query: SELECT *,…

Hi @Bjørn Tennøe , The Table Transformer macro can lookup as many tables as you need by the default Lookup preset, but you need a column with unique data (for example, issue keys, employees' names, etc.) to match the corresponding cells into the same rows. As you can see, here I combine my result report from three separate…

Hi @cendre , We can suggest trying our app - Table Filter and Charts for Confluence. Maybe it has been already installed for your instance. The plugin and its Table Filter, Pivot Table and Chart from Table macros work with the Jira Issues macro perfectly well and allow you to create Jira reports and visualized dashboards…

Difficult to say honestly, especially what concerns Cloud formatting. I've also found several issues for Server/DC and Cloud where customers ask Atlassian to make the Jira Issues column width resizeable: https://jira.atlassian.com/browse/CONFSERVER-36044 https://jira.atlassian.com/browse/CONFSERVER-23286…

Seems there is no any workaround with the standard Confluence tools.

Hi @Jamie Abbott , It is possible with the help of the Table Filter and Charts for Confluence app and its Table Transformer macro that allows advanced table cells formatting. Wrap your Jira Issues macro into the Table Transformer macro body and use custom SQL queries, for example: SELECT *, FORMATWIKI("{cell:width=100px}"…

Hi @Daisy Fischlein Steffensen , The basic conception is the same: you insert the Table Transformer macro and wrap two tables inside its body - the Jira Issues table and an additional manually created table for your comments. To lookup the tables, you'll need a unique field. As we don't use any custom fields, I choose the…

Yes, it's a paid app: filtering is only one part of the available functions. The addon supports Cloud/Server/DC and provides Excel-like features (pivots, table calculations, conditional formatting, table merging, pagination, various kinds of charts based on static and dynamic data, import/export to CSV, etc.). It may come…

Hi @varun ganesh , We can suggest using the following workaround: use the Chart from Table macro provided by the Table Filter and Charts for Confluence app. Wrap your table with any additional columns you need (containing links, pictures, etc.) in the Chart from Table macro and create a bar chart: Here is your page in the…

Hi @Satish Bhandari , You may try the Table Filter and Charts for Confluence app. Use the filtration button at the top right corner of your page or go to the editor and manually wrap your Page Properties Report macro in the Table Filter macro: Now you'll be able to export the whole report or the filtered report to the CSV…

Hi @Katarina Palm , As I understand from the Atlassian documentation, the table id selection may be only required if your page structure is very complex, for example, you use section and column macros inside the chart macro body and your tables are all mixed up. If you use a simple layout, then it is not necessary to fill…

Hi @Oana , We can suggest trying our app - Table Filter and Charts for Confluence. Use the most simple JQL query for your Jira Issues macro (such as "project = qwerty") and wrap the macro into the Table Filter macro body. You'll be able to filter (and save the results!) in the page view mode using a friendly Excel-like…

Hi @Tommy , As I understand, you have one big report created with the help of the Page Properties Report macro. And you need a second report based on the same Page Properties macros but not the full one - you don't want to collect the full row, you just need a part of the row (several cells). If this is the case, then…

Hi @Eric Senn , As I see, you need to somehow filter the Jira Issues macro in a more user friendly way than JQL query. We can suggest using the Table Filter and Charts for Confluence app. Wrap your Jira Issues in the Table Filter macro and apply the required filters: Here we show several projects with the help of the…

Hi @Giulia Frontalini , You may report this inconvenience to the Atlassian support. As a workaround, try to use additional filters to get the exact information you need. Use the Table Filter and Charts for Confluence app (search for the Table Filter macro in the macro browser - maybe the plugin is already installed for…

Hi @Krzysztof Tomicz , As for now you may try the Table Filter and Charts for Confluence app to sort the Decision Report macro. Wrap the report in the Table Filter macro body and you'll immediately get sortable columns. Without the Table Filter macro: With the Table Filter macro: Besides you'll be able to predefine the…

Hi @Santanu Roy , If your hosting type is Server/DC, just wrap your Table Transformer macro in the Pivot Table macro. All our macros are compatible, the Pivot Table macro will recognize the output of the Table Transformer macro as a regular Confluence table. Check our recent blog post where we nest Table Transformer <-…

@Alexander Stoyanov , @Dom , please, check if the version of the Table Filter and Charts for Confluence app is 6.1.0 or newer. Here is our documentation about cells formatting with the Table Transformer macro. You'll find a lot of use cases there. If the version of the app is up-to-date but you still can't reproduce our…

Hi @AME , As usual standard Confluence macros work with static content (except such macros as Jira Issues and Page Properties Report macro). So try to use additional plugins, for example, the Table Filter and Charts for Confluence app and its Table from CSV macro that can output data from Google Sheets/Google Drive, and…

Hi @Santanu Roy , You have two options to solve the problem. The first one is to choose the Preserve original sorting type of sorting for your Pivot macro. If the default sorting or the sequence of mentioned items in the original table suit you, it will be a perfect workaround: The second option is to use an additional…

Hi @Lucas Dias , Maybe I haven't got your case right, but what about the standard Jira Issues macro? You should be able to choose the fields (and custom fields as well) that you want to display on your Confluence page. Or is your case to populate custom fields in Jira using information that is stored in Confluence? Seems…