Versions Compared

Old Version 19

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Sireesha Dugginapeddi [Appfire] (Inactive)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article explains how we can use SQL macro of This article explains how to use SQL macro of the SQL for Confluence app in a user macro section of Confluence. In this article, we considered This article presents inserting a simple SQL statement in the user macro.

Instructions

  1. Prerequisites: Make  Make sure the database connection is successful using the SQL for Confluence app app.
    1. Log in to your Confluence instance as an administrator.
    2. Navigate to Image RemovedImage Added(Cogwheel) > Manage apps.
    3. From the left sidebar, select Select the SQL app > View and modify data source profiles and  from the left sidebar and ensure that connection to the database is successful.
      Image Modified
  2. We You can perform this action in using two methods.
Expand
titleMethod 1:
  1. Insert SQL macro.
    Image Modified
  2. Enter the SQL statement as required. In this example, a query is used to retrieve data from the persons table.
    Image RemovedImage Added
    Image RemovedImage Added
  3. Take Copy the storage of the page:
    Image Modified
    Image RemovedImage Added
  4. Navigate to Settings → > General Configuration → > User Macros and click click the Create a User Macro link to create a new user macro.
    Image Modified
  5. Fill in the required parameters and Categories as per the requirement.
  6. Insert the storage format in the Template and saveclick Save.
    Image RemovedImage Added
  7. Now use the user macro in the confluence page.
    Image Removed
    Image Added

Output:
Image RemovedImage Added


Expand
titleMethod 2:
  1. Navigate to Settings → > General Configuration → > User Macros and click click the Create a User Macro link to create a new user macro.
    Image Modified
  2. Fill in the required parameters and Categories and Categories as per the requirement.
  3. In the Template section, fill Enter the SQL query including the output format and data in the Template section, enter data source details, and save the macroclick Save.
    Image Modified
    Image Modified
  4. Now use the user macro in the confluence page.
    Image Modified

Output:

Image Modified