Functions converts any field given in a parameter call with XPATH expression.
Following parameters are obligatory:
| Type | Notes |
|---|---|
| ANY | Any value, SQL or Java type. Although this functions is design to handle java objects. |
| VARCHAR | Valid 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