Versions Compared

Version Old Version 9 New Version 10
Changes made by

Manisha Kharga

SriRama Batta

Saved on

Key

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

This article explains how to create the a form to add insert and update the data in to the database using a Groovy script.

Before we proceed with the instructions, below are the prerequisite:

  1. These apps needs to be installed on your Confluence instance:
    1. Run Self-Service Reports
    app.
    2. SQL for Confluence (Pro Edition)
    app.
  2. Follow this link to configure the data source profile for SQL for Confluence app.

Instructions

  1. Log into Confluence.

  2. Navigate to the required page and click  to edit the page.

  3. Insert Wiki Markup macro to write the script.

    Code Block
    languagegroovy
    themeMidnight
    {wiki}
{run:titleRun=DATA Display|anchor=result}

        {run}

          {run:id=update|replace=choice:Add::radio::Add::Update,id:1:Id (for update):integer-select:1:1000,type:dog:Select DB:select::MYSQL_new user:MYSQL_new          user:Mysql_confluence:Mysql_confluence,hand1:default:operational_hand_off_status:text,hand2:default:project_status:text,hand3:default:Resource Type:text|titleRun=Add|autoRun=true|anchor=result|focus=choice}
           {anchor:result}

            {hide:showIf=Add:$choice}

            {sql:dataSource=Mysql_confluence|contentPropertyPrefix=sql.}

            INSERT INTO report (Project_status,Resource_type,operational_hand_off_status)VALUES('$hand2','$hand3','$hand1');

            {sql}

            *Row Updated*

            {hide}

            {hide:hideIf=Add:$choice}
            {sql:dataSource=Mysql_confluence|contentPropertyPrefix=sql.}
            UPDATE report set Project_status = '$hand2', Resource_type ='$hand3',operational_hand_off_status = '$hand1' where report_id = $id
            {sql}
            {hide}
        
{run}
        
  {run-now}
            {hide:showIf=1:%property_sql.update_count%}
            *Row Added*
            {hide}

  {run-now}
            ----
            h3. Results
            {sql-query:dataSource=MYSQL_new user}
            select report_id,Project_status,Resource_type,operational_hand_off_status from report
            {sql-query}
       
  
{wiki}


  4. Click Save and the form will be displayed . The macro is displayed as mentioned below:

  5. Select the option choice: Add. After entering the data for the required field, Click Add to insert a new record and Update to edit the record.
  6. Enter data the required data and click Add to save the data into the database.
  7. Data will be is added/updated to the database and displayed as shown below:
    Select the option: Update.  a. Select the Id for which you want to update the record.
     b. Enter the value for the respective field you want to update.
     b. Click Add.
    Image Removed


Info
Test the above the example on non-production environment before implementing it in on production.