Katerina Kovriga {Stiltsoft} Expert

Your current version of Confluence is supported by the app. I've checked the case on the Confluence 7.4.0 and couldn't reproduce the issue. Tried both the standard pdf export of the whole page and the export of the result table via our macros. Also used merged headers in the source tables - everything works fine for me.…

Try to remove the T1."XXX" reference from the first part of your query: SELECT CASE WHEN T1.'RN' IN (1,5,9) THEN "Test" WHEN T1.'RN' IN (2,6,10) THEN "Dev"... ----> SELECT CASE WHEN 'RN' IN (1,5,9) THEN "Test" WHEN 'RN' IN (2,6,10) THEN "Dev"... The query tries to look for the "RN" column in the first table but there is no…

Thank you for reaching out! Start with browser cache, maybe it could solve the issue.

Hi @Karthika_Natarajan , You may try to nest the second query in the FROM destination of the first query. Here is an example for you: SELECT *, CASE WHEN 'RN' = 2 THEN "Test" ELSE NULL END AS 'Status' FROM (SELECT rownum() as 'RN', T1.'Project' FROM T1) Hope this may help your case.

Hi @Simon Müller , I assume we are talking about our Table Filter and Charts for Confluence app and its Chart from Table macro. Try to clear your browser cache and repeat the actions. Also if you have Server/Data Center hosting, check the version of the app - the current one is 8.1.1. If you use an older version, please…

Hi @Luke , If you have our Table Filter and Charts for Confluence app, you may use its Table Transformer macro to merge you Jira Issues macro with a manually created table with checkboxes. Please look into the second part of this Community thread for more details.

Maybe try to raise a new question regarding custom fields with a more wide topic mentioning Jira Issues macro and tags that include Jira as well. It may attract more attention from other Community members and/or Atlassian team, hope they will be able to suggest some tips.

Maybe the type of the field can be the issue indeed - the Jira Issues macro shows the custom fields as usual.

And does the Jira Issues macro show something inside these fields? Without the Table Filter macro, I mean. Because you posted good screenshot from Jira itself, but not the correct output of the Jira Issues macro in Confluence. The Table Filter macro can't delete any data in the table columns but leave the headers as they…

And if you use our Table Filter and Charts for Confluence app and need to reuse/collect multiple-row tables (the Page Properties Report macro collects only one-row tables), you may consider the Table Excerpt/Table Excerpt Include macros.

Hi @Glenn Quirynen , Do you use the standard Confluence export to pdf? I assume that your hosting is Server/Data Center and for me everything works well in our instance (see the last table - as you can notice, this combined table consists of three mini-tables from three different pages, the headings are not duplicated).…

Hi @Peter Notenbaert , If you use our Table Filter and Charts for Confluence app in your company, you may adjust column width with the help of the Table Transformer macro.

Hi @alex vincent , You can see the precise results from the source Jira Issues table when clicking on the corresponding sectors/bars of the charts based on your pivot tables. Please see the two screenshots with my comments attached below: P.S. I assumed that you are using our Table Filter and Charts for Confluence app and…

Hi @Gaby , Our backlog is in our internal Jira instance, we've added your vote and the link to this thread to the ticket, so we'll get back to you here once the feature is implemented.

Hi @GuntherLord , You may use our Table Filter and Charts for Confluence app to merge Jira Issues output with a plain manually created Confluence table - please check the second part of this Community thread where I give a similar example with screenshots.

Hi @Smadar Sagi As usual our macros don't impact the page loading time - try to remove the macros and leave only the Jira Issues macro to compare. If the problem persists, you may raise a support ticket: go to the upper right corner -> menu ... -> View Storage Format and attach it to the ticket (we'll recreate your macros…

Hi @Amna Shahbaz , If we are talking about the Table Filter macro, then it's our Table Filter and Charts for Confluence app. You can sum rows (output the total column) using the Table Filter macro - please check this part of our documentation. All the numeric cells will be summed up. And if you want to sum up only specific…

Hi @Netanel Mazuz , The Table Filter and Charts for Confluence is our add-on - try to deinstall and install the app once more. If the problem persists, raise a ticket with Atlassian and share it with us via our support portal.

Hi @Esteban Borja Lopez , Please check what version of the Table Filter and Charts for Confluence app you use - it seems that you need to update the plugin. The current version is 8.1.1, the FORMATWIKI function was added in the 6.1.0 version and amplified since then. What concerns merged cells in headers, the Table…

Hi @Ann Lin , Try to browse Atlassian Marketplace and find some apps that recreate Confluence tables from CSV files. Our own app that is Table Filter and Charts is a paid add-on cause its a complex one and provides many options that can almost replace Excel in Confluence. But "light" apps can be free. The second problem is…

Hi @Ben Wells , You may also consider using additional apps to amplify standard Confluence tools. For example, we can suggest trying our Table Filter and Charts for Confluence add-on. Its Table Excerpt/Table Excerpt Include macros allow you to collect multiple-row tables (the native Page Properties Report macro collects…

Hi @Peter Liu , As you've mentioned our Table Filter macro, I can say that it should be compatible with the TableView macro. You'll be able to achieve two cases with it: 1. Filter your table by names/codes/etc. (set common or inversed filters): here we talk about hiding the unwanted rows. 2. Hide the unwanted columns (you…

Hi @Smadar Sagi , @Hagai Danenberg , I've consulted with our developers and was provided with a following example - hope it may come in handy for your cases: SELECT 'Second td'->split("</")->0->split(">")->1 AS 'Second', SUBSTRING('Second td', INSTR('Second td', "</td>") + 5)->split("</")->0->split(">")->1 AS 'Third' FROM…

@Bart Demol , Please can you provide us with your SQL query that you are trying to use and get a mistake? And I also forgot to mention that you may use the Table Filter macro in combination with the Chart from Table macro and filter the Gantt chart by the specific resources (not to show all of them at once).

Thank you, I'm going to consult with our developers now and get back here, if they come with any suitable solution.

Maybe you can give us a result table that you want to achieve from the source one and the current SQL that you are stuck with? Not sure how you want it to look like. The Table Transformer uses AlaSQL library, maybe our developers will be able to help.

As for the Stacked Column chart, I can suggest trying the Pivot Table <- Chart from Table macros sequence to get smth like that:

Hi @Bart Demol , Not sure that your original idea is possible due to stacking not only percentages but very different time periods. As for now I can suggest using the Gantt Chart provided by the Chart from Table macro with the following settings: It seems to me that my variant visualizes the percentages better. And you may…

Hi @Sai velagala , The Table Transformer macro is provided by the Table Filter and Charts for Confluence app and based on the AlaSQL library (the first link leads to the macro documentation with multiple examples of queries and corresponding use cases). The query from the stackoverflow works well for your case: SELECT…

The original date format works fine - you should change it not in the preview, but in the Adjustments tab of the macro settings. Also it should be not MM yy (it corresponds to February 2022) but M-yy as I have mentioned before (it corresponds to the Feb-2022): Don't choose the date format from the predefined options - type…