Versions Compared

Old Version 3

changes.mady.by.user Jonathan Muse

Saved on

compared with

New Version Current

changes.mady.by.user Jonathan Muse

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table plus
applyColStyleToCelltrue
columnTypess,s,s,s
heading0
multiplefalse
enableSortingfalse

Parameter name

Type

Required

Description

datasourceName

String

Yes

Datasource name or JNDI name. For Jira database, this is set to "jdbc/JiraDS" by default.

sqlstring

String

Yes

SQL string.

Return Type

String []

Error Handling

Throws SqlException

Examples

Example 1

Code Block
languagejs
string [] results = sql("datasourceName", "select project_id from project_lookaside where project_code='" + project + "'");
//Note: this example is open to SQL injection if 'project' is not the standard issue project (derived) but a variable supplied by user. Take care.

...