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

[Akanksha Anand Kushwaha]

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

[Anna Mitina _Stiltsoft_]

@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:

1. You're using " for identifying columns when you should use '. The " are for the text inside the cells.
2. 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-]

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?