This article explains how to input data through a form and retrieve results from a database using the Run Self-Service Reports for Confluence and SQL for Confluence apps.
Instructions
- Make sure that database connection is successful using the SQL for Confluence app.
- Log into your Jira instance as Jira administrator and navigate to
(Cog wheel) > Manage apps - From the left sidebar, select the SQL app > View and modify data source profiles and ensure that connection to database is successful.
- Log into your Jira instance as Jira administrator and navigate to
- Insert SQL macro inside Run with a user form and parameters macro:
- Insert SQL statement as per your requirement. In the example below, we consider retrieving data from the table persons:
- Edit the Run with a user form and parameters and click Add my first field in Field settings:
- Select Field type and add Field key. Here the Field key is considered as per the SQL statement mentioned above (PersonID):
- To enter more than one field, click Add field:
- Save the macro settings and publish the page.
- Provide input and click Run. As per the above SQL statement and input data entered in the form, data is retrieved from the database:
Any text in the SQL macro body that begins with $ immediately followed by a Field key from Run with a user form and parameters macro will be replaced by the values provided in the form.