This article explains how we can use SQL macro of SQL for Confluence app in a user macro section in Confluence. In this article, we considered inserting a simple SQL statement in the user macro
Instructions
- We can perform this action in two methods.
- Make sure that database connection is successful using the SQL for Confluence app.
- Log into your Confluence instance as an administrator and navigate to
(Cog wheel) > Manage apps. - From the left sidebar, select the SQL app > View and modify data source profiles and ensure that connection to the database is successful.
- Log into your Confluence instance as an administrator and navigate to
- Insert SQL macro
- Enter SQL statement as required. In this example, a query to retrieve data from the persons table is used.
- Take the storage of the page:
- Navigate to Settings>General Configuration>User Macros and click Create a User Macro to create a new user macro.
- Fill in the required parameters and Categories as per the requirement.
- Insert the storage format in the Template and save.
- Now use the user macro in the confluence page.
Output:
- Navigate to Settings>General Configuration>User Macros and click Create a User Macro to create a new user macro.
- Fill in the required parameters and Categories as per the requirement.
- In the Template section fill the SQL query including the output format and datasource details and save the macro.
- Now use the user macro in the confluence page.
Output:
