| Info | ||
|---|---|---|
| ||
This routine is available starting with katl-commons SIL Engine™ 1.0, changed in 2.5.8. |
Syntax
...
For selects returning multiple rows, it concatenates the values (for instance you select 2 values and the select returns 4 rows, you will have 2*4 = 8 values). For updates, it returns the update count.
Parameters
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. |
Starting with katl-commons 2.5.8, the routine accepts multiple parameters, in this case the sql statement being pushed as prepared into the database (check the second example below for right syntax). The old syntax is still functional too.
...
| Code Block |
|---|
struct Person {
string fName;
string lName;
number age;
}
Person [] results = sql("datasourceName", "SELECT fName, lName, age FROM person WHERE group_member = 'Y'");
//checks to see if there are results there are skipped for brevity, but
//now you can iterate over and use the dot notation, and 'age' is really a number.
string firstResult = results[0].fName + " " + results[0].lName + " " + results[0].age; |
Notes
| Note |
|---|
To configure the data source, check the SQL data sources configuration chapter. |
...
| Filter by label (Content by label) | ||||||||
|---|---|---|---|---|---|---|---|---|
|