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

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

Instructions

1. For dynamic value substitution, you need to use $ with the field name. Write a SQL statement in the SQL macro as shown below:

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

2. Add the above query inside a run with a user form and parameters macro and provide field values for the form by editing the run macro as shown below screenshot:
   
   
   
   
3. Provide the values for the fields as shown below and click on run button and result of the macro with get displayed.