Table Transformer sql - multiple Filter Results macro

[Chii]

Hi, Could someone please help on this...

I'm adding a 2nd Table Transformer in my Confluence page.  

The Table Transformer contains 4 tables using "Filter Results" macro and I want to use sql to create a new table joining all 4. 

My query shows correct result in the Table Transformer preview,

SELECT 
T1.'Key', T1.'Business Analyst' BA, 
T4.'Assignee' PMO, 
T3.'Assignee' Designer, T2.'Assignee' 'UI/UX Designer'
FROM 
T1 LEFT JOIN T2 ON T1.'Key' IN T2.'Links' 
LEFT JOIN T3 ON T1.'Key' IN T3.'Links'
LEFT JOIN T4 ON T1.'Key' IN T4.'Links';

but when I save the page it shows an error:

"Error: Column does not exist: Business Analyst"

I think the Table IDs are changing whenever I do something in the query. 

I don't mind using less Filter Results, but I don't know how to write the sql for it. 

[Katerina Kovriga _Stiltsoft_]

Hi @Chii ,

Please define what macros you use inside the Table Transformer macro? It seems that they are not our macros and that they are not standard Confluence macros as well.

Maybe it is coming from this app from another vendor? https://botronsoft.atlassian.net/wiki/spaces/ILV/pages/1130594441/Visualize+in+Confluence#Filter-Results-Macro

Maybe smth is wrong with the compatibility of the macros.

You may use a simple SQL query (select the 'Business Analyst' column from the first Filter results macro and see if the column is returned well when the page is published).

And you may recreate your Filter Results tables manually (just create 3-4 row tables with similar headers and data) and test your SQL query on them (to make sure that it works correctly when the page is published).

Then raise a support request. Attach a page storage format (menu ... -> View Storage Format, if you don't see the option, ask your Confluence administrator to do it for you) and the output of each Filter Results macro (with visible headers). 

P.S. Ans check the version of the Table Filter and Charts for Confluence app beforehand - the current one is 8.6.2.