This article explains how to use SQL macro of the SQL for Confluence app in a user macro section of Confluence. This article presents 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. - Select the SQL app > View and modify data source profiles from the left sidebar and ensure that connection to the database is successful.
- You can perform this action using 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.
- Copy the storage of the page:
- Navigate to Settings > General Configuration > User Macros and click the 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 click Save.
- Now use the user macro in the confluence page.
Output:
- Navigate to Settings > General Configuration > User Macros and click the Create a User Macro link to create a new user macro.
- Fill in the required parameters and Categories as per the requirement.
- Enter the SQL query including the output format in the Template section, enter data source details, and click Save.
- Now use the user macro in the confluence page.
Output:
