/
Script - sql query (groovy)
Script - sql query (groovy)
Run a simple query against a direct JDBC connected database (mySQL)
How to use
Example scripts can be used in one of 3 different ways:
- Directly via url: https://bitbucket.org/bobswift/confluence-script/src/master/src/itest/resources/sqlQuery.groovy
- Download to the script folder in your Confluence home directory and use script=#sqlQuery.groovy (Note: Please find the sqlQuery.groovy file attached to this page)
- 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
{groovy:output=wiki|script=#https://bitbucket.org/bobswift/confluence-script/raw/3340d53e9f10b4b587e61a1a6323179d88bbf487/src/itest/resources/sqlQuery.groovy|dbServer=mySqlDBServer} {groovy}
, multiple selections available,
Related content
sql
More like this
sql
More like this
sql
More like this
selectIssues
selectIssues
More like this
selectIssues
selectIssues
More like this
runFromSql
runFromSql
More like this