Page Comparison

This article explains how to input data into using a form and retrieve the results from the database using the Run Self-Service Reports for Confluence and SQL for Confluence apps respectively.

Instructions

1. Make sure that database connection is successful using the SQL for Confluence app.
   
   1. Log into your Jira Confluence instance as Jira an administrator and navigate to Image RemovedImage Added(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 Insert SQL macro inside a with a nested Run with a user form and parameters macro:.
   
3. Insert Enter SQL statement as per the requirementrequired. In the this example below, we consider retrieving data from the table persons:, a query to retrieve data from the persons table is used.
   
   
4. Edit the Run macro and add with a user form and parameters and click Add my first field in Field settings:
   
   
5. Select the Select Field type and add Field key. Here the Field field key is considered as per the SQL statement mentioned above in step 3 (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 Data is retrieved from the database based on given SQL statement and the input data entered in the form, data is retrieved from the database:.
   
   

...