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,
T1.'Key', T1.'Business Analyst' BA,
T3.'Assignee' Designer, T2.'Assignee' 'UI/UX Designer'
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.
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.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event