Page Comparison

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 screenshot:
   
   Image Added

2. 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.

   
   

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

...