Skip to end of banner
Go to start of banner

How to use SQL for Confluence with Run Self Service Reports for dynamic content

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 12 Next »

This article explains how to use SQL for Confluence with Run Self Service Reports to display dynamic content on a page.

Instructions

  1. Insert a Run with a user form and parameters macro in a Confluence page and provide field values for the form by editing the Run macro as shown below screenshots:


  2. Insert another macro: SQL macro inside the Run macro in a Confluence page and write a SELECT statement in the SQL macro settings as shown below:

    Select CREATOR,CREATIONDATE from SPACES WHERE SPACEID='$Space Id' AND SPACEKEY='$Space Key';

    Any text in the SQL macro body that begins with $ followed by a Field key from the Run with a user form and parameters macro is replaced with the values provided in the form.

  3. Provide the values for the fields as shown below:

  4. Click Run to display the results.


This example is from the SQL Server database.

  • No labels