I can't seem to find this anywhere.
I am using SQL to pull data into a confluence page. I know graphs are able to manipulate this data into chart form, but I am wondering are there any other tools/methods to manipulate the sql data.
For Example - If I use SQL to pull a list of Successes and Failures, I would like to be able to highlight the successes in green / set a status macro to green / or something along that nature.
If anyone can point me in the right direction in handling a case like this, I would be most appreciative
Thanks
So I actually figured out this answer myself.
You are able to manipulate the SQL code to spit out macro data and Confluence will recognize the macro and run it.
Example:
select case when "Revenue" <= "Plan" then '{status:colour=red|title=Bad}' else '{status:colour=green|title=Good}' end from products
Generally, you just need to write your SQL so that it creates the correct markup to produce the results you want. For example, use a case statement to generate the appropriate emotion icon markup based on the data.
Example producing wiki markup:
select case when "Revenue" >= "Plan" then '(/)' else '(x)' end from products
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yea I was thinking most of the flexability is within the SQL code. Was just wondering weather I could nicely link it with some confluence tools.
Anyway, thanks for the response!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So I actually figured out this answer myself.
You are able to manipulate the SQL code to spit out macro data and Confluence will recognize the macro and run it.
Example:
select case when "Revenue" <= "Plan" then '{status:colour=red|title=Bad}' else '{status:colour=green|title=Good}' end from products
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.