...
| 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 =',' |