[Confluence] SQL Result Manipulation

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

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes

Answer accepted

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" &lt;= "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.

Comment

1 vote

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" &gt;= "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.

Comment

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.

Comment

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" &lt;= "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.

Comment

Was this helpful?

Thanks!

Confluence

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

[Confluence] SQL Result Manipulation

2 answers

1 accepted

Comments for this post are closed

Was this helpful?

Thanks!

TAGS

Atlassian Community Events