Versions Compared

Old Version 2

changes.mady.by.user Ravya Mutyala

Saved on

compared with

New Version 3

changes.mady.by.user Ravya Mutyala

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This article explains how to input data through a form and retrieve data from

...

the database using Run Self-Service Reports for Confluence and SQL for Confluence apps.

Instructions

  1. Make sure that a database connection is successful using SQL for Confluence app.
    1. Select the Image Added(Cog wheel Image Removedwheel) > Manage apps
    2. Select the SQL app > View and modify data source profiles and connection to the database is successful.

  2. Insert the an SQL macro inside a run  Run with a user form and parameters macro:
  3. Insert the SQL statement as per the requirement. In the example below, we considered 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 that is PersonID:

  6. To enter more than one field click on Add field:
  7. Save the Macro settings :and publish the page.

  8. Enter the details and click Run. As per the SQL statement and details entered in the form on the confluence page, data will be retrieved from the SQL database and will be shown on the confluence page:


Info

Any text in the macro body that begins with $ immediately followed by a key

found in the replace parameter list will

will be replaced by the

value. Values will be provided by a user submitting a form from the page based on the replace parameter. Default values can be specified

values provided in the form.