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:

View source

Requirements

  1. Scripting for Confluence 4.x or above
  2. Confluence 4.1 or above

Tested

This script (latest version in Bitbucket) is tested during release testing using GINT - Groovy Integration Test Framework

{beanshelloutput=wiki|script=#https://bitbucket.org/bob_swift/examples/raw/tip/confluence/beanshell/sqlQuery.bsh}
{beanshell}