SINCE V1.3.0

Steps

1. Create a new Confluence page or edit an existing Confluence page
2. Insert SVG Chart Macro
3. Insert a code block macro inside the SVG Chart Macro

4. Edit the code block macro and choose SQL in the syntax highlighting field. (Currently only support SQL query statement starting with select )

5. 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:

select s.spacename,count(case when contenttype='PAGE' then contenttype else null end) as 页面, count(case when contenttype='ATTACHMENT' then contenttype else null end) as 附件 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 group by s.spacename;