Function GETFIELD

Owned by Piotr Bojko
Last updated: Aug 23, 2018

This function returns the value of issue field, regular one or custom field.It requires following parameters:

TypeNotes
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