| Excerpt |
|---|
This function returns the value of issue field, regular one or custom field. |
It requires following parameters:
| Type | Notes |
|---|
| BIGINT | Id of an issue | Note |
|---|
Not the key of an issue. |
|
| VARCHAR | Valid syntax is | Code Block |
|---|
[`]fieldname[`] [PATH `valid-xpath-expression`] |
PATH, CAST, AS are keywords. fieldname is obligatory, where PATH expression is not. valid-xpath-expression is an XPATH expression, see Handling ANY (java objects) type with XPATH
| Note |
|---|
Please note the use of grave accents - ` . Grave accent is obligatory for valid-xpath-expression. For fieldname grave accents can be omitted. |
Examples:
| Code Block |
|---|
'`ReporterObject` PATH `emailAddress`' |
|
...
| Code Block |
|---|
|
select
AUX.ASISSUEKEY(ID),
PROJECT,
REPORTER,
AUX.GETFIELD(ID, 'PROJECT'),
AUX.GETFIELD(ID, 'REPORTER'),
AUX.GETFIELD(ID, 'customfield_10000')
from issues
limit 100 |
| Code Block |
|---|
|
select
AUX.ASISSUEKEY(ID),
AUX.GETFIELD(ID,'`PROJECT` PATH `name`')
AUX.GETFIELD(ID,'`REPORTER` PATH `emailAddess`),
AUX.GETFIELD(ID, 'Sprint PATH `count(.)`')
from issues
limit 100 |