Katerina Kovriga {Stiltsoft} Expert

Hi @Nidhi , It seems that it is a duplicate question for this one. Still I'll repeat my previous answer here: you may check this thread (my second answer) with the same case exactly. The solution is based on our app - Table Filter and Charts for Confluence. The answers are detailed and with screenshots - you may just…

Hi @Scott Porwancher , The standard Confluence macros that allow you to collect one-row tables from different Confluence pages are the Page Properties/Page Properties Report macros. If you want to amplify your report and collect multiple-row tables as well as several tables from the same page, you'll need additional apps,…

Hi @RItam Bose , The problem is in the new Cloud editor - everything will be working just fine if your instance is Server/Data Center. Confluence Cloud doesn't allow macro nesting so you can't create sequences as Expand macro <- Table Filter macro <- table. And because of this limitation the Table Filter and Charts for…

Hi @Nidhi , You may check this thread (my second answer) with the same case exactly. The solution is based on our app - Table Filter and Charts for Confluence. The answers are detailed and with screenshots - you may just repeat everything step-by-step.

Hi @Christian Peters , The workaround may be to hide the control button for the Table Filter macro - please check the guide here. And you may also change the filters' displaying mode (set it to headers as you are having it now, filtration panel or hide everything at all).

Hi @Varun Krishnamurthy , You may try to browse the Marketplace and search for free or paid apps that provide such macros. For example, our company develops the Table Filter and Charts for Confluence app which main features are filtering, aggregating and visualization of tabular data. And the add-on also provides the Table…

You may also see all the releases with new features and bug fixes listed on the Marketplace in the Releases section.

Yeah, the Jira Issues macro with different languages was supported in the 7.3.0 version. And later versions had other useful features like collecting page meta data via the Table Excerpt Include macro (now it can collect page name, creator, created and modified dates, etc.), dependencies for Gantt chart, etc. It will be…

And here is another more simple workaround for similar cases - please check this abstract. But again we strongly recommend to update the app firstly.

Hi @Emily Berg , Please check the version of the Table Filter and Charts for Confluence app - the current one is 7.7.4. I suppose that the problem is in the browser language settings: some users have American English and some use British English. We had such requests from our customers in the past and improved the Jira…

Hi @Emily Berg , Here I am with a rather complex SQL query from our developers: SELECT * FROM T1 LEFT JOIN T2 ON T1.'Tested-by-key'->match("(^|[0-9])" + T2.'TER Key' + "([^0-9]|$)") As far as I can see, the query matches your case.

I'll consult with our developers tomorrow and get back to you - can't come up with a better idea for the case with different prefixes. As a straightforward workaround, you may use several Transformers - each one for every prefix (I assume that one or both of your tables come from the Jira Issues macro, so you may filter…

Hi @Emily Berg , I think we should stick to the more specific SQL query that I mentioned first - the one that includes the name of the project. If I remember your case right, you are trying to merge the two tables that look similar to this screenshot: The second table was divided by the internal Table Transformer macro:…

Hi @PASCAL CARMINATI , We can suggest using our app - Table Filter and Charts for Confluence. To turn your Excel file into a Confluence table, you may use the Table from CSV macro. And to freeze columns/rows both for the recreated CSV table and for manually created Confluence tables, you may use the Table Filter macro and…

You know, the first thought is indeed to create a separate page for every application (its name should match the application name). Then you'll be able to keep your artifacts in a table on the corresponding page. Each table should be wrapped into the Table Excerpt macro (the macro works similar to the Page Properties macro…

Hi @Jyoti Lahoti , Maybe our app will be helpful - Table Filter and Charts for Confluence. You'll be able to filter your tables on the fly or set a predefined filtering panels for your colleagues. The source table: Filtering on the fly: Filtering using the panel: And you may reuse your source table with the help of the…

Yeah, it is possible to transpose the Page Properties Report macro with the help of the Table Transformer macro: But here the number of your columns will grow with the number of the pages containing the Page Properties macro. I still suggest trying to collect your report using the Table Excerpt/Table Excerpt Include macros…

Now I see and you are right, it's really not possible due to Cloud limitations - you can't nest macros with bodies in the new editor. But why do you need to wrap the source one-row table wrapped into the Page Properties macro further into the Table Excerpt macro? You may reuse the whole Page Properties Report macro or…

Maybe I didn't get what you mean - here I reuse the Page Properties Report macro with the help of the Table Excerpt/Table Excerpt Include macros in Cloud: The Table Excerpt Include macro can be wrapped further into the Table Filter macro for filtering and hiding columns or into the Table Toolbox macro for aggregating and…

Hi @Ines Weißgerber , We can suggest using our app - Table Filter and Charts for Confluence. You'll be able to collect and reuse manually created tables, Page Properties Report macro and other tabular macros with the help of the Table Excerpt/Table Excerpt Include macros and filter the result table (show only rows that are…

Hi @Jannis Louw , I've consulted with our developers and got a more complex SQL query that may suit your case: SELECT *, FORMATWIKI( "[Bla-bla link|" + T1.'Link'->tfView->match("href=([^ >]*)")->1->slice(1, -1) + "]" ) AS 'New Link' FROM T* Now the Link and the New Link columns mirror each other and contain the same…

Hi @Jannis Louw , I'm not sure if I've gotten your case right but here is the option that I can suggest (if it doesn't suit you please clarify the question and attach some screenshots). So here is your page in the edit mode: The first column contains raw links that you manually paste for your wiki page. The second column…

Hi @Jens Peter Johansson , We can suggest using our app - Table Filter and Charts for Confluence. Besides filtering and aggregating tabular data, the add-on provides the Chart from Table macro that includes an advanced Gantt chart with different custom features, dependencies, etc. Maybe you'll be interested in a live demo…

I've changed the original answer (not sure what version you have seen), so you may try the option with one Table Transformer and the following SQL query: SELECT DISTINCT * FROM (SELECT * FROM T*)

Hi @Raphael Chagnoleau , At first I want to mention our new feature regarding the Table Excerpt/Table Excerpt Include macros: if your tables are manually created, I assume that you reuse them with the help of the Table Excerpt macros and collect them with the help of the Table Excerpt Include macro. If this is the case,…

Hi @Sangmesh , I can see my name among the tags, so I assume that you use our Table Filter and Charts for Confluence app for your instance. As usual, we suggest wrapping your Jira Issues macro into the Table Filter macro and add this combination to your template. The Jira Issues macro should return all the basic data, its…

Hi @davin , please raise a support request here. Attach the page storage format (upper right corner > menu ... > View page storage), and we'll try to look into the issue.

Please update the app and check if the issue is still present. If yes, then create a support request - I've warned our support team about the issue.

Hi @Sadeesh Narendran , it's a strange situation - if you see the column into the Pivot Table macro, it should be also visible via the Table Filter macro. So, please, check the version of your app - the current one is 7.6.5. And raise a support request here. Please attach your page storage format: upper right corner of the…

Hi @Karen Michaels , I've never come across such case - not sure if it's a bug or smth because as usual if the Jira Issues macro responds to your query and lists the related issues, then it counts the totals as well. But maybe you use our app in your company - Table Filter and Charts for Confluence. Then the workaround may…