Versions Compared

Key

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

...

  1. Install SQL for Confluence using UPM. Add-on version 5.6 or higher is required.
  2. Update the properties file used to load the macro security configuration by adding something like the following:

    No Format
    sql-file=*ANY
    sql-file.datasource.*=*ANY
    sql-file.file.example.sql=*ANY


  3. In UPM, find Macro Security for Confluence and press the Configure button.
  4. Load the updated properties file from step 2.
  5. Add an example SQL script to the <confluence-home>/script directory on the Confluence server. Only scripts in this directory or subdirectories are accessible.

  6. On a page, add the SQL File macro specifying the file to be the name of the file used in step 5.
  7. Preview to see the results of the query. Note that no page edit restrictions are required.

Image Removed