Page Comparison

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

...

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

   Code Block
   theme Midnight
   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.