Page Comparison

...

1. Make sure that database connection is successful using the SQL for Confluence app.
   
   1. Log into your Jira instance as Jira administrator and navigate to (Cog wheel) > Manage apps
   2. From the left sidebar, select the SQL app > View and modify data source profiles and ensure that connection to the database is successful.
      
2. Insert an SQL macro inside a Run with a user form and parameters macro:
   
3. Insert SQL statement as per the requirement. In the example below, we consider retrieving data from the table persons:
   
   
4. Edit the Run macro and add Field settings:
   
   
5. Select the Field type and add Field key. Here the Field key is considered as per the SQL statement mentioned above (PersonID):
   
   
6. To enter more than one field, click Add field:
   
7. Save the macro settings and publish the page.
   
   
8. Provide input and click Run. As per the above SQL statement and input data entered in the form, data is retrieved from the database:
   
   

...