Fuction AUX.PATH

Functions converts any field given in a parameter call with XPATH expression.

Please read Handling ANY (java objects) type with XPATH for more details about using XPATH in Smart QL.

Following parameters are obligatory:

TypeNotes
ANYAny value,  SQL or Java type. Although this functions is design to handle java objects.
VARCHARValid XPATH expressions which will be applied to an object given in first parameter.

The result of these function will be the value computed from XPATH applied to given object. See following example

Number of sprints to which issue is assigned.
SELECT jql.Key, AUX.PATH(jql.Sprint, 'count(.)') NUMBER_OF_SPRINTS 
FROM TABLE(AUX.JQL('Key, Sprint','')) jql