Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,838
Community Members
 
Community Events
165
Community Groups

Table Transformer sql - multiple Filter Results macro

Chii I'm New Here Jun 10, 2022

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. 

Confluence_Table Transformer.png

 

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. 

1 answer

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.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

974 views 15 27
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you