Script - sql query (beanshell)
Run a query against the Confluence database connected via an application server data source. Lists all spaces in the Confluence instance.
How to use
Example scripts can be used in one of 3 different ways:
Directly via url: https://bitbucket.org/bob_swift/examples/raw/tip/confluence/beanshell/sqlQuery.bsh
Download to the script folder in your Confluence home directory and use script=#sqlQuery.bsh
Copy the script into the macro body
View source
Requirements
Scripting for Confluence 4.x or above
Confluence 4.1 or above
Tested
This script (latest version in Bitbucket) is tested during release testing using unnamed link
{beanshelloutput=wiki|script=#https://bitbucket.org/bob_swift/examples/raw/tip/confluence/beanshell/sqlQuery.bsh}
{beanshell}