nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

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.

All comments

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

filter

table

table-filter

table-excerpt

table-filter-and-charts

confluence-data-center

table-transformer

table-filter-charts-spreadsheets

page-properties-report