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 GINT
{beanshelloutput=wiki|script=#https://bitbucket.org/bob_swift/examples/raw/tip/confluence/beanshell/sqlQuery.bsh}
{beanshell}