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.

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

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}