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 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:

   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 in the SQL macro

   Image Removed

   Image Added

   Info
   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:
   Image Modified
   
4. Click Run to display the results.
   

...