Function converts any input parameter into readable text. This is useful for a simple casting java objects to text.
Following parameters are obligatory:
SELECT jql.Key, AUX.PATH(jql.Sprint, 'count(.)') NUMBER_OF_SPRINTS...
Type | Notes |
|---|---|
| ANY | Any value, SQL or Java type. Although this functions is design to handle java objects. |
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.
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT
FLOOR(STARTDATE TO DAY) WORKDAY,
COUNT(ID) ENTRIES,
AUX.ASTEXT(COLLECT(AUX.ASISSUEKEY(ISSUE))) ISSUES,
AUX.ASDURATION(SUM(TIMEWORKED)) WORKED,
SUM(TIMEWORKED) WORKED_IN_MS
FROM CORE.WORKLOGS AS W
WHERE W.AUTHOR = ? AND STARTDATE BETWEEN ? AND ?
GROUP BY FLOOR(STARTDATE TO DAY)
ORDER BY FLOOR(STARTDATE TO DAY) ASC |