Page Comparison

This article explains how to get the list of pages in confluence containing the SQL macro using the app SQL for Confluence (Pro Edition).

Instructions

Follow the steps:

1. Login to the Confluence instance.
2. Go to the required confluence page and edit the same.
3. Select the Data source profile.
   a.If you are aware of Database profile names than add SQL macro and select the Data source profile as shown in the below image.

           Image Modified
           b. If you are not aware of the database profile name. Then follow the below steps: 
             - Login as Confluence Admin and go to General Configuration.
             - Click on the app SQL for Confluence (Pro Edition) under Bob Swift Configuration.
             - Click on View and modify data source profiles tab.
                

      4. Run below SQL query to get the list of DB profiles created in your Confluence instance. In your SQL profile table, there will be number for this table so replace XXXX value with the number.

select profile_name from AO_xxxxx_SQLPROFILES;

          Click on Save setting to get the list of Database profiles from the above query.

        
        5. Click on the Save button on the confluence page.
       

...

   Click on Save settings to save the SQL query.

Image Modified

7. Click on Save button on the page.

8. This SQL query will list all the pages containing SQL macro in your confluence space.

...

9. Click on Save button on the confluence page to publish the page.