Turn SQL output in a confluence table to a different view

[Carla Valdegas]

I like to use the output of my SQL query table on a conference page to display a different view instead of a table. Do you use CSS code? I am using ScriptRunner macro.

[Benjamin · Accepted solution]

Hi @Carla Valdegas ,

ScriptRunner is one way of doing it. There's a number of add-ons that helps display SQL data in confluence as well in the market place. For example, this one below:

https://marketplace.atlassian.com/apps/225/sql-for-confluence-pro-edition?tab=overview&hosting=datacenter

-BEn

[Carla Valdegas]

I would like to create a ScriptRunner macro to display employee profiles on a confluence page that connects to a SQL database. There is a macro called Profile List but don't see where you can pull employee data from SQL. Do you have any examples? Really appreciate it. Thanks!

[Benjamin]

Just in time. Adaptavist ScripRunner has posted an example in their library:

https://library.adaptavist.com/entity/display-sql-results-from-an-external-database-macro?_ga=2.80182935.1498145943.1664401883-1216766160.1598983343

This should get your what you need.

-Ben

[Carla Valdegas]

Thank you Ben! I was able to display SQL employee data into a table in confluence earlier using Scriptrunner. What I would like to do is to be able to make the employee name clickable and display a dialog box that contains the employee information like location and department with a few icons for email, phone, and chat. Can I do that with Scriptrunner? Thanks so much for your help! Carla