SQL macro default, no results and formatting help

I'm using the SQL macro for inventory purposes.  I'm very new to database queries.  I pieced this together from examples and previous work by others.  I was going to use Play SQL but the dynamic user field has been removed on the Confluence pages.  I was looking into PocketQuery but I can't get the LIKE matching to work (question posted here as well).  I have three questions:

  1. I can't seem to figure out how to make the default values blank without the query being interpreted as a blank (waiting for user input).  So, I just put NULL in the field for now.
  2. If the query comes back with no results, it displays the query for some reason.  Is there a way to hide that and only display "The query has returned no data."?
  3. A third question but it's not too important.  My query below uses LIKE.  But if an exact match comes up, is there a way to highlight the value green? 

Capture.JPG

1 answer

This widget could not be displayed.
Davin Studer Community Champion Oct 31, 2014

Using LIKE '%NULL%' will not work. The way you work with NULLs is below ...

 

...
a.asset_description is NULL or i.itemnumber is NULL
...

The NULL is just an arbitrary value I placed in the value default. It's actually the string called "NULL" and not the value of NULL. Because I can't figure out how to allow SQL Macro to have a default value that is blank without an error, I just place the string "NULL" in the default value field.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

627 views 8 6
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you