The AUX schema contains helpful tables for a variety of common tasks:
List all the queries saved by the trusted users
SAVEDQUERIES | ||||||
---|---|---|---|---|---|---|
Column | ID | NAME | AUTHOR | MODIFIEDON | DESCRIPTION | QUERY |
Type | BIGINT | VARCHAR | VARCHAR | TIMESTAMP | VARCHAR | VARCHAR |
Index | x | x |
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 |
---|---|---|---|---|---|
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' |