This article explains how to update values into the database table for a column and display on the Confluence page using Run Self-Service Reports for Confluence and SQL for Confluence apps.
Instructions
Insert a Run with a user form and parameters macro in a Confluence page and provide field values for the form by editing the Run macro as shown below screenshots:
Insert SQL macro in a Confluence page and write an update query in SQL macro as shown in the below example:
UPDATE BI_SUPP SET [Status] = @status,'notes' = 'notes' + @notes FROM BI_SUPP WHERE PkTaskId = @pttaskid
Insert another SQL macro and write a select query as shown below to get the output of the above update query:
Select pkTaskID, Status, Notes FROM BI_SUPP;
- Add the above two SQL macros inside the Run macro as shown in the below screenshot and save the Confluence page.
- Provide the values for the fields as shown below:
- Click Run to display the macro results.
This example is from the SQLServer database.