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 edit the macro to provide field values for the form by editing the Run macro as shown below screenshots:
   Image Removed
   

2. Insert another macro: SQL macro inside an 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
   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 Removed
   Click Run and click Run to display the results.Image Removed

Consider the following sample data and click Run:
Image Added

The query results are displayed as:
Image Added