[Confluence] SQL Result Manipulation

[bchi]

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

[bchi · Accepted solution]

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

[Bob Swift OSS (Bob Swift Atlassian Apps)]

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

[bchi]

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!

[bchi]

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