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

[Katerina Kovriga {Stiltsoft}]

Hi @Surya Anem ,

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

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

The second Jira Issues macro: a table with results

The preview of the Table Transformer macro

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 

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

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

[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).

[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:

[Surya Anem]

Below is the screenshot of both the tables in view mode without the table transformer. 

I think its behaving the same. Dont understand what's going wrong :( 

[Katerina Kovriga {Stiltsoft}]

Please, try to recreate everything on the new page. If this doesn't help (it seems like you are doing everything right and it should be working), raise a support ticket, we'll try to investigate the issue more thoroughly.

[Katerina Kovriga {Stiltsoft}]

We've checked your case both on our Cloud and Server instances - everything works ok.

Is your hosting a Cloud one as it is shown in the description of the question? 

Maybe it is a mistake, and you use an old Server Confluence and outdated version of the Table Filter and Charts app?

[Surya Anem]

This is the version of confluence - Confluence 6.15.8 and, my mistake, its not cloud version. It is Server instance. I picked the wrong option. 

As suggested, am going to try and re create this on a new page. However, I have this same table in 4 pages and where ever the filter has no data, i have this issue

[Katerina Kovriga {Stiltsoft}]

And what is the app version? 6.0.1 is the current one.

And the up-to-date Confluence Server version is 7.8 (look here).

It seems that a simple update may help your case.