The query returned no rows.

[tippani sri satya sai durga prasad]

hi, Is there any way to display  empty table instead of below message("The query returned no rows)?

i have a query. if no yellow and red records then it wii display a empty result instead of "the query returned no rows"

my expected output if no records are there see below image

is there any possible way? 

can any one help us?

[Katerina Kovriga _Stiltsoft_]

Hi @tippani sri satya sai durga prasad ,

We can suggest removing the "The query returned no rows." message using the CSS:

<style> 

.table-joiner .wrapper .aui-message.info.aui-message-info { 

display: none; 

} 

</style>

Now your users won't see any confusing messages.

[Katerina Kovriga _Stiltsoft_]

Don't know why, but I didn't see your last screenshot while answering - to add an empty table, you'll need another Table Transformer macro and this empty table as well (the CSS still remains the same):

The query for the second Table Transformer: SELECT * FROM T1

And here is your page in the view mode:

[Ram Chandrasekaran]

Hi @Katerina Kovriga _Stiltsoft_ , where should the CSS go? I cannot find a place to add it within the Table Transformer. Any help is much appreciated.

Thank you

Ram

[Ram Chandrasekaran]

BTW, just read through your other responses. Turns out, I cannot use HTML macro in our Confluence Server, so that's out of the question. Need a workaround if there is one. Thanks very much.

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Ram Chandrasekaran,

Please notice that if you update the app, you can use the Messages customization option right in Table Transformer to hide the message: