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 T1 doesn't exist Error in Table transform

Surya Anem

Hi - I created two tables with JIRA filters in Confluence using filters- One table has all the planned story points, other one has all the completed story points

Now, I tried to use a table transform on these two tables to display the following

1. Count of Planned Story Points

2. Sum of Planned Story Points

3. Count of Completed Story Points

4. Sum of Completed Story Points

5. % complete

Below is the query I used

Select (SELECT count(T1.'story points') from T1) as 'Completed Stories' , (Select SUM(T1.'story points') from T1) as 'Completed Story Points',
(Select count(T2.'story points') from T2) as 'Planned Stories', (select sum(T2.'story points') from T2) as 'Planned Story Points',
ROUND((Select SUM(T1.'story points') from T1)/(select sum(T2.'story points') from T2)*100,0) as '% Completed'

The query works fine when there is data in both T1 and T2 tables. However, none of the above columns get displayed when one of the table is empty. Is it possible to display atleast #1,#2 when Completed Story points table is empty or viceversa

Accepted answers

All comments

Katerina Kovriga _Stiltsoft_

Hi @Surya Anem ,

We've recreated your case and used your original query for the Table Transformer.

Jira 11.png The first Jira Issues macro: no filtered results, empty table

Jira 22.png The second Jira Issues macro: a table with results

Jira 33.png The preview of the Table Transformer macro

Jira 44.png As you can see, everything works just fine.

Maybe we don't get what is wrong with your empty table - please, clarify what do you exactly mean. Is something wrong with the permissions? Maybe you don't have access to some projects/issues and get errors with the Jira Issues macro?

Surya Anem

Hi Katerina,

Thank you for the quick response. This is exactly what am doing. However, this is what I get in the final result as there are no rows in the second table

T2 Doesnt exist main page.PNG

Just to validate, I changed the whole query and did the below select and have the same T2 error

T2 doesnt exist.PNG

Is there some configuration am missing. When filtering via JIRA for each of the tables, the only field am selecting is story points. Is that right ? Is there anything else i need to select

Story points.PNG

Katerina Kovriga _Stiltsoft_

And how does your empty Jira table look without the Table Transformer?

It should be like this - your Story Points heading and an empty line. It seems that smth is wrong with the Jira Issue macro, the Table Transformer can't recognize it as a proper table (the screenshot below is taken from the view mode of my test page). Jira 55.png

Katerina Kovriga _Stiltsoft_

And we also choose just the Story Points field to show in the Jira Issues macro configuration - so you're doing everything right:

Jira 66.png

Welcome!

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

Quick Links

Find more posts tagged with

confluence

cloud

jira-software

jira-software-cloud