TABLE TRANSFORMER - Using columns from page property macro from children grouped by parent page

[Roberta Bortolotti]

Hi,

I am using two page properties macros and wrapping them with Table Transformer to create one table. One page properties macro comes from the children pages and one from the parent page. Basically, I want this table to list specific information coming from all children pages grouped by the parent page.

Is there a way to do that? 

If I should be using a different macro, please let me know.

Thank you,

Roberta

[Stiltsoft support]

Hi @Roberta Bortolotti ,

As you've mentioned the Table Transformer macro, it seems that you use our Table Filter, Charts & Spreadsheets for Confluence app.

So, you may take the Table Excerpt/Table Excerpt Include macros to collect your data. The macro allows you to choose from a various set of meta data to show along the collected tables:

• Source page title
• Parent page title
• Space title
• Space key
• Labels
• Source page excerpt (abstract)
• Author
• Last modifier
• Created
• Updated
• Page version
• Page ID

Seems that the Parent page title is exactly what are looking for.

[Roberta Bortolotti]

Thank you, @Stiltsoft support 

Somehow the metadata is not showing when I wrap the Table Excerpt Include with the Table Transformer macro. What am I missing?

Best

[Stiltsoft support]

You may check your chain step-by-step: check the Show as a report option in the Table Excerpt Include macro - your collected tables will be merged into one big report as in Page Properties Report.

Then you choose to show the Parent page title metadata and the 'Parent page' column is automatically added to your report.

Then you wrap the Table Excerpt Include macro in the Table Transformer macro with a simple default SELECT * FROM T* query: the 'Parent page' column remains as it is.

If everything works as expected till now, then check the real SQL query that you use. Maybe you don't list the 'Parent page' column in it.

If the 'Parent page' column disappears using the default SQL query, please check the version of the app. The current one is 12.3.3 - this version is installed in our test instance and everything works fine. If yours is an older one, please update.