Hide Empty Table if JQL / Jira Filter Returns No Results (No Issues Found)

[Emily Berg]

Hello Community,

I have a Confluence page with a JIRA Issue/Filter macro.  When the filter returns zero results it shows a table header followed by "No issues found".  Is there a way to hide the table under this circumstance, i.e. I only want to see the table and results if there are issues found.

Image shows current implementation with "no row" table appearing in Confluence page.  I would like to hide this when zero results are returned.

Thank you,

Emily

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Emily Berg ,

If you use the Table Filter and Charts for Confluence app in your company, you may use its Table Transformer macro to hide the "No issues found" message.

Wrap your Jira Issues macro into the Table Transformer macro body and choose the following tab into its settings:

Here is how your full result table will be displayed:

And here is an example of the empty table (no rows returned):

Hope this may help you case.

[Emily Berg]

This worked great, thank you!  I did add in the HTML macro as suggested by Katerina below to completely remove the banner.  Thank you for your fast response.

Emily

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hello @Emily Berg ,

Please use the following CSS to remove the message: 

.table-joiner .wrapper .aui-message.info.aui-message-info{ display: none; }

Add the following CSS to the global, space stylesheet or the HTML macro.

Please note that the 7.1.13 version of Table Filter and Chart already provides the possibility to hide all your source content. Please update and hide it in your case.

Before:

After applying CSS and hiding all content:

Katerina
Stiltsoft

[Emily Berg]

Hi @Katerina Rudkovskaya _Stiltsoft_ and @Katerina Kovriga _Stiltsoft_

This is a great start, thank you! Two follow-up questions:

1. Although the table data no longer appears within the Confluence page, it DOES still appear when I export the page to PDF (using Scroll PDF).  Any thoughts on how to translate to the export?

2. I see that the HTML text is specific to removing the banner.  Is it possible to remove the banner AND replace it with text?  E.g. Remove the banner, but display "No Issues Found".  And again, I would like only the text to be exported, not the banner and not the table.

Thank you!!

Emily

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Emily Berg

1. We'll investigate it and get back to you.

2. Please try to create a small manually created table with the following words inside it: "No Issues Found". Then wrap it and your source table with Table Transformer and use the following SQL query:

SELECT * FROM T1

By the way, in this case the source table is not exported.

Katerina
Stiltsoft

[Emily Berg]

Hello @Katerina Rudkovskaya _Stiltsoft_ ,

Excellent solution, thank you my export looks great!

Emily

[Katerina Rudkovskaya _Stiltsoft_]

Hello @Emily Berg ,

We've released the fix for thу following issue in the 7.2.0 version:

1. Although the table data no longer appears within the Confluence page, it DOES still appear when I export the page to PDF (using Scroll PDF).  Any thoughts on how to translate to the export?

Katerina
Stiltsoft

[Chris]

Hi @Katerina Rudkovskaya _Stiltsoft_ 

does this also work for the chart from table macro?How?

I tried (within a html macro as described)

<style>

.table-joiner .wrapper .aui-message.info.aui-message-info{ display: none; }
.table-chart .wrapper .aui-message.info.aui-message-info{ display: none; }

</style>

as I use tables and charts, which might have an empty result set.

BR

Chris

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Chris,

As far as I understand you'd like to hide these messages in your case:

Please use this CSS then:

<style>

.table-joiner .wrapper .aui-message.info.aui-message-info{ display: none; }
.tf-chart-message.no-table-message { display: none !important; }

</style>

Katerina 
Stiltsoft

[Rachi Manwal]

How can I print a custom message when there are no rows returned?

[Katerina Kovriga _Stiltsoft_]

Hi @Rachi Manwal ,

You may use the option given by @Katerina Rudkovskaya _Stiltsoft_ on 25 Mar, 2021 with an additional Table Transformer and a mini-table.

[Stiltsoft support]

Hi guys,

We've added the possibility to customize the standard macro messages for our macros.

Here are the screenshots for the Table Transformer and Chart from Table macros, but the same settings were also introduced for the Table Filter and Pivot Table macros:

Hope that now your experience with the Table Filter and Charts for Confluence app will be more pleasant.