Table Transformer not fetching data from rows with content Properties macro inside multiple page

Question

I have added the plugin for the table filter by Stiltsoft - Table Filter, Charts & Spreadsheets for Confluence

1. I have multiple Confluence pages with the same labels and the same content properties macro with different data in each page.

2. I created a "Content Properties Macro" inside the "Table transformer macro".

Even though the SQL query is correct, the values are not being passed to the macro.

Below is an example page macro I have on all pages:

SQL query:

Transformer Macro and output:

Is the Slitsoft plugin compatible with the Content Properties Macro? In my Confluence setup, the Page Property and Content Property are the same, but the data is still not displaying.

CAN YOU HELP HERE

Clara Vega _Simpleasyty_ · Answer

Hi @Akanksha Anand Kushwaha ,

This is a really interesting use case. It looks like the challenge is not only the formula itself, but also getting the data from multiple pages into one table in a simple way.

We have been working on a simpler approach on the Simple Table side for cases like this, where page data can be collected based on labels and then brought into a table for further work.

I am not sure yet whether it would fully match your exact setup, but it does sound quite close to what you are trying to achieve. If you would like, feel free to contact our support team and share your use case with us — we would be happy to take a look and see whether it could fit.

Anna Mitina (Stiltsoft) · Answer

@Akanksha Anand Kushwaha,

Thank you for submitting this question.

I'm Anna from the Table Filter, Charts & Spreadsheets for Confluence app.

There are two main issues with your SQL query:

* You're using " for identifying columns when you should use '. The " are for the text inside the cells.
* At the end of your SQL query, you're missing FROM T1, which would mark where the data should be taken from.

Please let me know if it helps :)

Marc -Devoteam- · Answer

Hi @Akanksha Anand Kushwaha

Is there any information on this in the documentation of the app?

If there is not, this might be not compatible, but simplest way to get this information is to reach out the Stiltsoft support.

@Stiltsoft support could you help out here?