Page Comparison

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

1. 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:
   Image Modified
   Image Modified
   

2. Insert SQL macro in a Confluence page and write an update query in SQL macro as shown in the below example:

   Code Block
   theme Midnight
   UPDATE BI_SUPP SET [Status] = @status,'notes' = 'notes' + @notes FROM BI_SUPP WHERE PkTaskId = @pttaskid

   
   

3. Insert another SQL macro and write a select query as shown below to get the output of the above update query:

   Code Block
   theme Midnight
   Select pkTaskID, Status, Notes FROM BI_SUPP;

   
   

4. Add the above two SQL macros inside the Run macro as shown in the below screenshot and save the Confluence page.
   Image RemovedImage Added
5. Provide the values for the fields as shown below:
   
6. Click Run to display the macro results.