This function returns the value of issue field, regular one or custom field.

It requires following parameters:

Type

Notes

BIGINT

Id of an issue

Not the key of an issue.

VARCHAR

Valid syntax is

[`]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

Please note the use of grave accents - ` . Grave accent is obligatory for valid-xpath-expression. For fieldname grave accents can be omitted.

Examples:

'Key'

'`Key`'

'`ReporterObject` PATH `emailAddress`'

Fields supported by AUX.GETFIELD are the same as for AUX.JQL function.

Examples

select 
	AUX.ASISSUEKEY(ID), 
	PROJECT, 
	REPORTER, 
	AUX.GETFIELD(ID, 'PROJECT'), 
	AUX.GETFIELD(ID, 'REPORTER'), 
	AUX.GETFIELD(ID, 'customfield_10000') 
from issues 
limit 100

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

Function GETFIELD

Examples