Function AUX.ASTEXT

Owned by Piotr Bojko
Last updated: Jan 09, 2019
1 min read

Function converts any input parameter into readable text. This is useful for a simple casting java objects to text.

Following parameters are obligatory:

Type
Notes
ANYAny 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

Example use of AUX.ASTEXT
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