Page Comparison

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

...

1. Insert SQL macro in a Confluence page and write a SELECT statement in the SQL macro settings as shown below:

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

   
   

   Info
   For dynamic value substitution, you need to use $ with the field name.

   
   

2. Insert another macro: Run with a user form and parameters and add the above SQL macro inside this Run macro.
   
3. Provide field values for the form by editing the Run macro as shown below screenshot:
   
4. Provide the values for the fields as shown below:
   Image RemovedImage Added
   
5. Click Run to display the results.
   Image Added

...