How to input data into a form and retrieve the results from database

This article explains how to input data 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 Confluence instance as an 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 database is successful.
      
2. Insert SQL macro with a nested Run with a user form and parameters macro.
   
3. Enter SQL statement as required. In this example, a query to retrieve data from the persons table is used.
   
   
4. Edit the Run with a user form and parameters and click Add my first field in Field settings:
   
   
5. Select Field type and add Field key. Here the field key is considered as per the SQL statement mentioned 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. Data is retrieved from the database based on given SQL statement and the input data entered in the form.