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:
Capture.JPG
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.