The AUX schema contains helpful tables for a variety of common tasks:

List all the queries saved by the trusted users

SAVEDQUERIES

It allows listing all the users' saved queries and search by ID or AUTHOR.

Example:

select * from AUX.SAVEDQUERIES where AUTHOR = 'admin'

ID	NAME	AUTHOR	MODIFIEDON	DESCRIPTION	QUERY

ID	NAME	AUTHOR	MODIFIEDON	DESCRIPTION	QUERY
364	folders	admin	2020-01-29 19:53:05.633		SELECT * FROM ZEPHYR.CYCLES c join ZEPHYR.CYCLEFOLDERS f on f.PROJECTID = c.PROJECTID and f.VERSIONID = c.VERSIONID and f.CYCLEID = c.ID where PROJECTKEY = 'MSP'
365	cycles	admin	2020-01-28 22:57:53.234		SELECT * FROM ZEPHYR.CYCLES where projectkey = 'MSP'

Convert strings into rows

SPLIT

This auxiliay table accepts a string as INPUT and a REGEXP expression and returns one record per result.

Ex:

SELECT 
  OUTPUT 
FROM 
  AUX.SPLIT 
WHERE 
  INPUT = 'Hello, World' 
    AND
  REGEXP =','

OUTPUT

OUTPUT
Hello
World

Note: Please read the Java String.split() function documentation for more details.