Katerina Kovriga {Stiltsoft} Expert

The Key column in T2 is populated manually - you type in the issue key in the first column and some comments and other notes into other columns. T2 shouldn't always match T1. For example, you may have 10 rows (10 issues) coming from the Jira Issues macro. But you want to leave comments only for the two specific issues. So,…

Seems that the Filter Results macro is not a standard Confluence macro and belongs to some other vendor. Try to use the Jira Issues macro instead.

Hi @Soham Das , As I saw the Table Transformer macro that belongs to our Table Filter and Charts for Confluence app, I decided to step in: the Table Transformer macro allows you to Look Up tables using the unique column, for example, the issue key. If you have two Jira Issues outputs (one with tickets, other with features)…

Hi @Bea Tea , You may check our Table Filter and Charts for Confluence app - seems that the second part of this Community thread concerns exactly your case.

Hi @Sreepriya Unnikrishnan , You didn't specify the type of your hosting, so I've checked the behavior both for Confluence Cloud and Server/Data Center (for the current app's version that is 8.8.2). I don't see such behavior regarding manually created tables and the Jira Issues macro (you've mentioned the Fix Version field…

Hi @Leona Vo , You may also try the following SQL query: SELECT *, DATEDIFF(day,T1.'Date',"today") AS 'Date Diff' FROM T* The date format for this example in the Table Transformer macro settings (Settings tab -> Date format) should be set as "m/d/y". Hope this also helps.

Hi @Vera Sinnamon , We can also suggest trying our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. These macros are an amplified version of the Page Properties/Page Properties Report macros, they allow you to collect multiple-row tables into one master report along with the…

Hi @Finn , If you work with multiple-row tables that you need to collect from child pages into one master report, we can suggest trying our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. Besides the creation of the combined report, you'll be able to show such meta data as…

Really not sure about the automatic emails, sorry but can't be of any help here.

Hi @Akarshi Taneja , If your company uses our app that is Table Filter and Charts for Confluence, you may use the Table Transformer macro to set the required column width and/or text alignment.

Unfortunately, we also didn't come with a better solution than yours. Indeed our examples may be shorter but they aggregate numbers and place them into one cell (not separate). What concerns the examples, it seems that we don't have any use cases with the mentioned keywords. The cases usually come from our customers, if…

Hi @Giuseppe F , The Table Transformer macro works with tables as with a mini SQL database, so to achieve your case we should manually check the dates' columns and assign what information we want to return for every condition. SELECT T1.'Number', T1.'Text', CASE WHEN T1.'Date 1' IS NULL THEN "No Dates" WHEN T1.'Date 3' IS…

Hi @Noori Fathima , The Table Transformer macro belongs to the Table Filter and Charts for Confluence app that is our add-on. Unfortunately, we don't have any functionality to trigger emails. Let's wait for answers from other vendors.

Maybe then its better to use the Jira Issues macro and the Pivot Table macro? Select the required projects in the Jira Issues macro and then group the issues by statuses directly?

Yes, it seems that all the Fix Versions' names are unique so your result table is combined as it is in my example. If, for example, you think that the "Accepted" status for the first project is the same as the "Ready" status for the second project, then you may use an additional Table Transformer macro for the…

Hi @Rama , You may use our Table Filter and Charts for Confluence app and its Table Transformer macro that supports the Two-Dimensional Chart macro. You may use the standard merge preset: The unwanted "Status T:" column and "Total Unique Issues:" rows can be further hidden with the help of the Table Filter macro.

And you may also try the following SQL query instead of your original one: SELECT T2.'OrderedStuff', CONCAT_VIEW_AGGR(FORMATWIKI(T2.'Value' + " \n")) AS 'Value' FROM (SELECT ("val1 " + T1.'OrderedStuff') AS 'OrderedStuff', T1.'Val1' AS 'Value' FROM T1 UNION SELECT ("val2 " + T1.'OrderedStuff'), T1.'Val2' FROM T1 UNION…

Hi @Kai Winter , At the moment we can't come up with a suitable solution for your case regarding that you may have a different number of ValX columns in the source table. We understand your idea with a schematic solution, but the Table Transformer macro is based on the AlaSQL library so now we don't see how to implement it…

Hi @SAlevy , At the moment it is not possible to perform calculations/aggregation in Confluence without any 3rd party apps. So you may look into the Table Filter and Charts for Confluence app (that is our add-on) - please book a suitable time-slot for a live demo here. The app allows you to filter, calculate, aggregate,…

Hi @Bart Hoegaerts , Use the standard Look Up preset to join your tables - join them by the unique column. Then your checkboxes will be recognized correctly: SELECT * FROM T1 OUTER JOIN T* ON T1.'Col 1' = T*.'Col 1' It is a standard query to join two tables by the unique 'Col 1' column. Your query that is SELECT * FROM T1…

Hi @Sarah Killeen , It seems that the initial info is still relevant. The Table Filter and Charts for Confluence (that is our app) was mentioned in this thread but regarding the Jira Issues macro aggregation. What concerns your case that is adding manually created columns to your Jira Issues macro, it is also possible to…

Yes, it displays only the data stored inside the Table Excerpt macro (similar to the Page Properties macro) and allows you to show extra meta data. But while the Page Properties Report macro allows you to collect only one-row tables, the Table Excerpt Include macro can collect multiple-row tables. I guess it's not this…

Hi @Daniel C. Igbokwe , If your company uses our Table Filter and Charts for Confluence app, you may use its Table Excerpt/Table Excerpt Include macros instead of the Page Properties/Page Properties Report macros. Our macros work similar to the native Confluence macros but allow you to select "excerpt" as a source page…

Yes, this macro is provided by the Table Filter and Charts for Confluence app (that is our add-on). The app is a paid one but it's free for Cloud 1-10 users. If you already have the add-on and are on Server/Data Center but don't see the Table Spreadsheet macro, then ask your Confluence administrator to update the app. The…

Can't think of anything besides the Jira Issues macro. But you may still refer to our support - maybe we'll be able to help with the issue.

And one more question - when you type in T1... do you see all the required columns in the autocomplete hint? The first column you refer to is T1.'Key', but the error points to the second column that is T1.'Business Analyst' - was it typed in manually or selected from the Table Transformer's autocomplete? Maybe there is a…

Then it looks like the problem is really in the compatibility of the two macros from different vendors. Ask your administrator which version of the Table Filter and Charts you use and contact our support team: they will try to check the performance and see what the issue may be.

So the sorting is messed up - check if the Date Format for your Table Transformer macro corresponds the current format. And you may try to add another Table Transformer macro between the Pivot Table macro and the Table Transformer macro with a cumulative count. Just with a default SQL query and a proper date format. If…

Yes, I see the issue - please wait for the reply of our support engineer.

Yes, please, raise a support request - we have the same macro' structure and it should be working fine. Attach the screenshot of your Table Spreadsheet macro or the macro itself as an attachment (the portal is confidential and our support team will try to recreate exactly your source table and look into the issue).