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 broken as soon as I add another row in one table

Aurélien Thazet

Hello everyone,

I created a status report in a Confluence to gather information from several project pages (each page have several table with the same structure) using Table Excerpt Includes and Table Transformers. Here is the current architecture of my status report:

I'm using some SQL to merge tables. Here are my requests:

Table Transformer for Table Excerpt Include 2

SELECT * FROM T1 

OUTER JOIN T* ON T1.'Page'=T*.'Page'

Table Transformer for Table Excerpt Include 1 & 2

SELECT T1.'Page' AS 'Project',

T1.'Product status' AS 'Project status',

T1.'Risk status' AS 'Risk status',

T1.'Project status update' AS 'Project status update'

FROM T1

OUTER JOIN T* ON T1.'Page' = T*.'Page

My table worked pretty good so far but I found an edge case today. If someone is adding another line or column in one of the project page tables, the report breaks. And I don't understand why since I didn't select this new line/column in my SQL requests.

For now I ask my colleagues not to modify the table in the project pages. But if there is a workaround I might be great.

Thanks for your time and your future help,

Aurélien

Accepted answers

Stiltsoft support

Hi @Aurélien Thazet ,

Please refer to our support portal and attach page storages of your master page and pages with the Table Excerpts (where your source tables are placed). We'll be able to replicate your pages with tables, macros and their settings and look into the issue.

To get the page storage, go to the upper right corner of the page -> menu ... -> View storage format. If you don't see the option, you may ask your Confluence administrator to do it for you.

All comments

Stiltsoft support

Hi @Aurélien Thazet ,

To get the page storage, go to the upper right corner of the page -> menu ... -> View storage format. If you don't see the option, you may ask your Confluence administrator to do it for you.

Aurélien Thazet

Hello,

Thanks for your reply. Unfortunately there is a lot of confidential information into these pages and my Confluence administrator, as well as my company, won't be agree to share them.

If you need more details to replicate the behaviour I have, please let me know

Stiltsoft support

The support portal is confidential, you'll be able to share your data there freely.

If some data is really sensitive (passwords, account credentials, etc.), you may replace it with some dummy data or smth but save the initial macros on the master page and on the page with the Table Excerpt. So that we'll be able to replicate the exact combination and all the settings.

Aurélien Thazet

Hello,

I checked internally and my company don't want to share this kind of information. So, allow me to explain my current setting.

Structure

Basically, I have several project pages with key information that I consolidate in a table on a master page. Here is the hierarchy

ALPHA, BETA and CHARLY are my project pages and the parent page is the consolidation page.

Project pages configuration

Each project page is created from a template with the same information. The key information are displayed in a Table (1) which is itself embeded into a Table Excerpt (2). And all the Table Excerpts across project pages have the same Name thanks to the template, Product Overview here (3).

I repeat the same process with all the information in my Project pages.

Consolidation page configuration

On my consolidation page, I have a Table Toolbox with the above hierarchy: A Table Transformer (1) which embeds a Table Excerpt Include (2) and another Table Transformer (3) which embeds a second Table Excerrpt Include (4).

The Table Excerpt Include 2 looks for an Excerpt called Project allocation and is configured like above.

The Table Excerpt Include 1 looks for an Excerpt called Product overview and is configured like above.

The SQL request for Table Transformer of Table Excerpt 2 is the one below.

SELECT * FROM T1 OUTER JOIN T* ON T1.'Page'=T*.'Page'

And the SQL request for Table Transformer of Table Excerpt 1 is the following one.

SELECT T1.'Page' AS 'Project',
T2.'POC' AS 'POC',
T1.'Product status' AS 'Project status',
T1.'Risk status' AS 'Risk status',
T1.'Project status update' AS 'Project status update'
FROM T1
OUTER JOIN T* ON T1.'Page' = T*.'Page'