Katerina Rudkovskaya [Stiltsoft] Atlassian Partner

Hi @[deleted], Please update the app once more - the latest version is 9.6.0. The issue with the LIKE statement was fixed by our developers.

Unfortunately, I don't think that your workaround will be successful. The Page Properties/Page Properties Report macros collect only one-row tables, other rows are simply dropped. Our Table Excerpt/Table Excerpt Include macros work similar to the Page Properties Report macro but collect multiple-row tables. But again we…

Hi @Mario Plagaro, We can suggest using our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. You’ll be able to reuse your source table several times (all the changes made to the original table will be reflected in the reused tables automatically) and filter/visualize each copy…

Hi @Gregory Ruth, If your company uses our Table Filter and Charts for Confluence app, you may use the following workaround with the Table Transformer macros: Here is the query for the internal Table Transformer macro: SELECT 'First Number'->split(".")->0 AS 'Number', * FROM (SELECT 'File'->split("-")->0 AS 'First Number',…

Hi @Samuel Stephens, My name is Katerina and I'm from the Stiltsoft team: the Table Filter and Table Transformer macros are ours. The issue with the Space Attachments macro relates to the native pagination of the macro. Unfortunately, it remains after the filtration and you may see empty pages. Other tabular macros without…

Hi @[deleted], Yes, please update the app - the current version is 9.5.2. Meanwhile, we've created a ticket to look into the AlaSQL library closely to see if anything can be done with the original query. Seems that it's quite a task - I'll return to this thread if we come up with any solution.

Hi @AG, Not sure as for now, but it looks like smth is messed up with table headers. As you can see on my screenshot, my tables have header rows: grey background is nor just color but real header row created by Confluence itself. Your tables (I use the very first screenshot for reference here) have gray background both for…

Hi @Justin Zhao, I see that you've already raised the ticket. I suppose you could find the message, right?

Hi @Laurie Huth, Please follow these steps: go to the Table Transformer macro settings and set the required date format that corresponds to the format used in your source table. Then use the following SQL query: SELECT 'Date', 'Month', CASE WHEN 'Month' = 1 THEN "January" WHEN 'Month' = 2 THEN "February" WHEN 'Month' = 3…

Hi @Laurie Huth, It seems that this question is a duplicate of this one, so please find the answer there.

Hi @Emil, It seems to be smth unusual with the "Description" field parsing: your SQL query is a working one and it operates as expected with other fields coming from the Jira Issues macro. We suppose that it may come from the "\n" end of the lines, we'll look into the issue closely. As a workaround, you may use the…

Hi @Kasra Ayz We can also suggest trying our app – Table Filter and Charts for Confluence.Its Table Transformer macro allows you to insert statuses based on a condition and/or color text/background based on these statuses. Furthermore, you’ll be able to filter and aggregate your report.And if you prefer Excel experience,…

As I've mentioned before, let's move to the support portal.Give us a screenshot of your source table (without any macros and with visible headers). We'll recrete it in our test environment.Then describe what you want to achieve with the SQL query. The Table Transformer macro is based on the AlaSQL query, so the syntax may…

Please attach screenshots to see the Table Filter macro settings here or via our customer portal.

Unfortunately, I can't see your screenshot (for me it's the name of the attached file and not a picture). So, judging by the macro name "Table Filter" I assumed that you are using our app.If this is not the case, please define what macro and what add-on you have - at the moment Confluence doesn't allow to filter tables…

Hi @Justin Zhao, As I see from your screenshot, you are using the Chart from Table macro: it means that you have our Table Filter and Charts for Confluence app installed for your instance. The mistake that you’ve got speaks for itself: the macro doesn’t see the table inside its body. It is not very clear how you are trying…

Hi @AG, Please follow my example. Here is a screenshot of your tables in the page edit mode: And here is your SQL query where we look up the two tables by the unique key column and rename other columns to distinguish if they are coming from the first or second table: SELECT T1.'Key Field', T1.'Total' AS 'Total from T1',…

Hi @Siddharth Dhotre, Please go to the page edit mode and make sure that your Jira Issues macro is wrapped into the Table Filter macro. Then go to the Table Filter macro settings and check what filters' mode you have: "filtration panel" or "filters in headers". Maybe you have the "hidden filters" mode switched on - then…

Hi @Hazem Ajlani, To collect multiple-row tables, you may use our app that is Table Filter and Charts for Confluence. Replace your Page Properties/Page Properties Report macros with our Table Excerpt/Table Excerpt Include macros. They work similar to the standard macros (consider labels, provide page source metadata, etc.)…

Hi @Katharine.Keskikyla, This is how the Page Properties/Page Properties Report macros work, they indeed collect only one-row tables. If your company uses our Table Filter and Charts for Confluence app, you may replace your macros with our Table Excerpt/Table Excerpt Include macros. They work similar to the standard macros…

Hi @Tanya Merkel If we are talking about our Table Filter and Charts for Confluence app, then you should use the Table Toolbox macro to nest several macros. Confluence Cloud doesn’t allow to wrap macros directly. So, to create macro sequences like “source table <- Pivot Table <- Table Filter <- Chart from Table” you need…

Hi @Eikra Shithil, Let’s move to the support portal then. Go to the upper right corner of the page -> menu … -> View Storage Format. Copy the data and attach your page storage to the ticket. We’ll be able to recreate exactly your page with the source tables and macro settings. If you don’t see the option, please ask your…

@Zeeshan Hasnain unfortunately, it's a known issue with low priority. You may try to gather more interest to the problem: CONFSERVER-55482

@Zeeshan Hasnain, in case of any questions or difficulties working with Table Transformer, please feel free to contact our support team. 

Hi @Julia Killian, If your company uses our Table Filter and Charts for Confluence app, you may combine two tables (the first one coming from the Jira Issues macro and containing your tickets and the second one that is manually created and containing your comments, notes, etc.) with the help of the Table Transformer macro.…

Hi @rava, Unfortunately, at the moment you can’t embed tabular Confluence macros into the Table Spreadsheet macro, but we have such feature on our roadmap. I’ll get back here once it is implemented. Meanwhile, you can transform and visualize the Jira Issues macro using other macros provided by the Table Filter and Charts…

Getting this kind of error: There was invalid HTML in the message body that has been removed. If you're posting a link, add the hyperlink using the editor. More details here. Has anybody know a workaround to manage this issue for today?

Hi @lin min, Here is an update from our team: now the Table Spreadsheet macro recalculates all the dates automatically after you reload the page.

Hi @Zeeshan Hasnain, There is indeed some trouble with custom fields coming from the Jira Issues macro: tabular data, list of statuses, etc. are displayed as plain one-row text in Confluence.

Hi @LeeSanne Guthrie Please notice that Atlassian has confirmed they indeed have rolled back to the old version of exporting: On November 14, 2022, we rolled back the Confluence PDF export feature to its previous implementation. We understand the rollback will impact some marketplace apps that depend on Confluence PDF…