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

0 votes
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 Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,522 views 25 14
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