SINCE V1.3.0
You need to Database Connection Configuration to be able to retrieve data from correct database.
Steps
- Create a new Confluence page or edit an existing Confluence page
- Insert SVG Chart Macro
- Insert a code block macro inside the SVG Chart Macro
Edit the code block macro and choose SQL in the syntax highlighting field. (Currently only support SQL query statement starting with select )
- Edit the code block macro, fill in the database name into the title field of code block macro. If the database name is not provided, the first available database will be used.
SQL Example
Issue count group by Project and Issuetype:
Confluence
select s.spacename as "Space Name",count(case when contenttype='PAGE' then contenttype else null end) as "Page", count(case when contenttype='ATTACHMENT' and prevver is null then contenttype else null end) as "Attachment", count(case when contenttype='BLOGPOST' then contenttype else null end) as "Blog" from CONTENT c join SPACES s on c.spaceid=s.spaceid JOIN SPACEPERMISSIONS sp ON s.spaceid=sp.spaceid where sp.PERMALLUSERSSUBJECT is null and sp.PERMGROUPNAME is null and sp.PERMUSERNAME is null and c.CONTENT_STATUS='current' group by s.spacename;