...
applyColStyleToCell | true |
---|---|
heading | 0 |
columnTypes | s,s,s,s |
multiple | false |
columnAttributes | style="background:#e5e7ea;font-weight:bold,,style="background:#e5e7ea;font-weight:bold, |
enableSorting | false |
...
Syntax
...
databaseAvailable(dbstring [, sqlstring])
...
Package
...
sql
...
Alias
...
Pkg Usage
...
available(dbstring [, sqlstring])
Description
Excerpt | ||
---|---|---|
| ||
Checks if the database is available. |
Checks if the database is available. Optionally, it can check also the availability of the results for the SQL passed in as the second parameter.
Parameters
...
applyColStyleToCell | true |
---|---|
columnTypes | s,s,s,s |
heading | 0 |
multiple | false |
enableSorting | false |
...
Parameter name
...
Type
...
Required
...
Description
...
dbstring
...
String
...
Yes
...
Datasource JNDI name or the datasource name. For Jira database, this is set to "jdbc/JiraDS" by default, if exported.
...
sqlstring
...
String
...
No
...
SQL string.
Return Type
Boolean (true/false)
Examples
Example 1
Let's suppose in our examples `TextField` is a custom field text already configured for the current Jira server instance and `TestDB` represents the database resource name configured in the server context. For more details see SQL data sources.
Code Block | ||
---|---|---|
| ||
TextField=databaseAvailable("TestDB"); //will set 'TextField' value to 'true' |
Example 2
Code Block | ||
---|---|---|
| ||
TextField=databaseAvailable("TestDB", "select pname from project"); //will set 'TextField' value to 'true' if the SQL passed in can be executed |
Example 3
Code Block | ||
---|---|---|
| ||
TextField=databaseAvailable("TestDB", "select pname from inexistentTableName");//will set 'TextField' value to 'false', because the SQL passed in cannot be executed |
Example 4
Code Block | ||
---|---|---|
| ||
TextField=databaseAvailable("InexistentTestDB", "select pname from project");//will set 'TextField' value to 'false', because the database resource does not exist |
Note |
---|
To configure the data source check the SQL data sources configuration chapter. |
See also
Filter by label (Content by label) | ||||
---|---|---|---|---|
showLabels | false | |||
max | 25 | |||
showSpace | false | |||
cql | label = "system_routine" and space = currentSpace ( ) | labels | array_routines||
Include Page | ||||
|