...
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 |
---|
Column | OUTPUT | INPUT | REGEXP |
Type | VARCHAR | VARCHAR | VARCHAR |
Index |
| x | x |
This auxiliay table accepts a string as INPUT and a REGEXP expression and returns one record per result.
Ex:
Code Block |
---|
|
SELECT
OUTPUT
FROM
AUX.SPLIT
WHERE
INPUT = 'Hello, World'
AND
REGEXP =',' |