...
- Install SQL for Confluence using UPM. Add-on version 5.6 or higher is required.
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
- In UPM, find Macro Security for Confluence and press the Configure button.
- Load the updated properties file from step 2.
Add an example SQL script to the <confluence-home>/script directory on the Confluence server. Only scripts in this directory or subdirectories are accessible.
- On a page, add the SQL File macro specifying the file to be the name of the file used in step 5.
- Preview to see the results of the query. Note that no page edit restrictions are required.