Katerina Kovriga {Stiltsoft} Expert

Then maybe I've got the question wrong - you really can access the page meta data where Excerpts are placed from the Include page but not the other way. Maybe other apps have such possibilities - let's wait for answers from other vendors.

The meta data belongs to the each page containing the Excerpt, not to the page containing the Table Excerpt Include macro. So, on the page with Table Excerpt Include macros you'll see info when the source pages were created and updated (when and by whom).

Hi @Christian P , We can suggest using our Table Filter and Charts for Confluence app and its Table Excerpt/Table Excerpt Include macros. These macros work similar to the Page Properties/Page Properties Report macros, but allow you to combine multiple-row tables instead of the one-row tables.

Hi @Sebastian , If it happens so that you use our Table Filter and Charts for Confluence app in your company, then you may use our Table Excerpt/Table Excerpt Include macros (they collect both multiple-row tables and paragraphs). The Table Excerpt Include macro allows you to show such page meta data as: * page * parent…

Hi @Martin Federico Valiente Phun , The Table Filter and Charts for Confluence app mentioned above is our add-on and it's available for Server/Data Center and Cloud. We'll be glad to organize a live demo for you and your team - please book a suitable time slot here.

We haven't encountered such issue before - this is one of the standard cases for our customers. They often create several links (or buttons with links) to various filter views of the source table. You may raise a support request and attach your page storage format (upper right corner -> menu ... -> View Storage Format).…

Hi @Neeta Nayak , If it happens so that you use our Table Filter and Charts for Confluence app for table filtration, then you may try to build the Burndown Chart with the help of our macros as well. The add-on supports the standard Jira Issues macro and the result chart will be based on this macro. Here is a step-by-step…

Then you have an old version of the app - the current one is 7.9.28, please, update. The feature was already present in the 7.2 version of the app and you may miss other new features such as collecting page metadata vie the Table Excerpt Include macro and, for example, dependencies for the Gantt Chart.

We can also suggest our Table Excerpt/Table Excerpt Include macros that are provided by our Table Filter and Charts for Confluence app. These macros allow you to collect paragraphs and multiple-row tables along with showing page metadata: - page - parent page - space - labels - excerpt - author - last modifier - created -…

If you don't update the source table very often, then you may use the Table Excerpt/Table Excerpt Include macros with the Output cached results option checked. Place the source table wrapped in the Table Excerpt macro on the page 1 and reuse it several times with the help of the Table Excerpt Include macro on the page 2…

Hi @Tom Carr , The Table Filter and Charts for Confluence app mentioned above is our add-on - you'll be able to filter manually created and macro generated tables (Jira Issues, Page Properties Report, Content Report Table, etc.) on the fly with the help of the Table Filter macro. Maybe you are interested in a live demo…

Hi @Egor Kharlamov , The Table Filter and Charts for Confluence app is our add-on and, as usual, its macros don't interfere the page load time. Please clarify what exactly do you want to achieve with the app? You've mentioned that your page has a "table include macros "table filter" and shown us an example of the link - as…

Hi @Tobias , It's an old question and I assume you've already found a solution, but in case somebody comes across this question due to the recent activity: if you use our Table Filter and Charts for Confluence app and its Table Filter macro to filter the Jira Issues macro, please make sure that the app's version is…

Hi @Maureen McManus , As @Fabian Lim has mentioned, our Table Filter and Charts for Confluence app and its Table Transformer macro can really do the trick: wrap your Jira Issues macro into our Transformer and list all the possible statuses and their colors via the custom SQL query. Here is an example for our local Jira…

Hi @Kerry McIlwain , As for now your case is not possible due to the new Cloud editor limitations - the new editor is based on iFrames and doesn't allow nesting.

Hi @James Hanley , If it happens so that you use our Table Filter and Charts for Confluence app in your company, note that the add-on also provides Table Excerpt/Table Excerpt Include macros that allow you to collect several excerpts from: * Current page * Specific page * Page and child pages * Page and all descendants *…

Hi @Heather Blue , Our app that is Table Filter and Charts for Confluence app also provides multiexcerpt macros - Table Excerpt/Table Excerpt Include. The macros allow you to give names to your Excerpts, collect several Excerpts from one page and automatically get Excerpts from * Page and child pages; * Page and all…

Our Table Filter and Charts for Confluence app provides the Table Excerpt/Table Excerpt Include macros: * they work similar to the Page Properties Report macro but allow you to collect multiple-row tables along with a great bunch of metadata (page title (link), author, created, labels, etc.) * and similar to the…

Hi @jeroen_wilmes , It seems to me that your case is not possible for the Cloud editor due to its internal structure: it is based on iFrames that mess up nesting.

Hi @Danielle Kopetzki , Please give us more info like it was suggested in the first answer. And specify the macro that you use - I suppose it's a standard Jira Chart macro? If it happens so that you use our app that is Table Filter and Charts for Confluence in your company, then we can suggest the following workaround:…

Hi @Priyanka khare , Maybe it happens so that you use our Table Filter and Charts for Confluence app in your company - the add-on can also help you to build a Velocity chart based on the Jira Issues macro. And here are other examples how to use the app with the Jira Issues macro - hope it may help.

Hi @Peter McCracken , As it was mentioned before, you can use the Page Properties/Page Properties Report macros to cоllect tabular data from other pages and show the page titles of these source pages. If you need to collect multi-row tables, then you may use our Table Filter and Charts for Confluence app and its Table…

You'll be able to compare dates via the Table Transformer macro as well, here is a somewhat similar example from the Community (the last comment). The cost of the app for different tiers is shown on the Marketplace.

Hi @suvarna dixit , We can suggest trying our app - Table Filter and Charts for Confluence. It's Table Transformer macro allows you to set statuses based on different conditions (the macro works with manually created and Jira generated tables). Here is an example regarding your case: SELECT *, CASE WHEN (T1.'Time Spent,…

Try this SQL query: SELECT T1.'Sprint', T1.'Start Date', T1.'End Date', T1.'To Do'->split(" ")->0 AS 'To Do', T1.'In Progress'->split(" ")->0 AS 'In Progress', CAST((T1.'To Do'->split(" ")->0) AS INT) + CAST((T1.'In Progress'->split(" ")->0) AS INT) AS 'Total', CASE WHEN DATEDIFF(day, 'Start Date', "today") < 0 AND…

Hi @emagnun , I can suggest trying to set statuses with the help of the Table Transformer macro. I guess that this is your table from our previous thread - I suggest leaving the current Table Transformer macro as it is (we already have a rather complex SQL query there with splitting and format changing). So, not to mess…

I've found your ticket - we'll look into the issue and I'll attach the link to this thread there. Again you pointed your hosting type as Cloud - it should be Server/Data Center as you see the version of you Confluence.

Try this SQL: SELECT T1.'Sprint', T1.'To Do'->split(" ")->0 AS 'To Do', T1.'In Progress'->split(" ")->0 AS 'In Progress', CAST((T1.'To Do'->split(" ")->0) AS INT) + CAST((T1.'In Progress'->split(" ")->0) AS INT) AS 'Total' FROM T* Adjust it to the third "Done" status, I have the two statuses.

Hi @Anna Szabó , I assume that the question tags are messed up and you use Confluence Server 7.4.1. I've checked the issue on our own Confluence Server 7.14.2 and the Table Filter app 7.9.26 (the latest version) and couldn't reproduce it. Got the idea about the equal numbers, and I also have several "1" and "6" numbers in…

No, and it is always better to leave this field blank if you use ROUND() inside the SQL query.