This article explains how we can use SQL macro of SQL for Confluence app in a user macro section of Confluence. In this article, we considered inserting a simple SQL statement in the user macro.
Instructions
- Prerequisites: Make sure the database connection is successful using the SQL for Confluence app.
- Log in to your Confluence instance as an administrator.
- Navigate to
Cogwheel) > 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.
- We can perform this action in two methods.
- Insert SQL macro.
- Enter the SQL statement as required. In this example, a query is used to retrieve data from the persons table.
- Take the storage of the page:
- Navigate to Settings → General Configuration → User Macros and click Create a User Macro link 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 link 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 data source details, and save the macro.
- Now use the user macro in the confluence page.
Output:
