Hi ,
IN server edition i can query test execution and test plan status by using test execution status and test plan sttaus in confluence server directly but now in cloud i am not able to do the same. Does Altassian blocked this ?
Ex:
Test Execution Status:
COALESCE(T1.'Test Execution Status',T1.'Testausführungsstatus') AS 'Test Execution Status',
COALESCE(MATCH_REGEXP(T1.'Test Execution Status',"(?<=PASS: )\d{1,4}","g"),0) as 'Pass',
COALESCE(MATCH_REGEXP(T1.'Test Execution Status',"(?<=TODO: )\d{1,4}","g"),0) as 'Todo',
COALESCE(MATCH_REGEXP(T1.'Test Execution Status',"(?<=EXECUTING: )\d{1,4}","g"),0) as 'Executing',
COALESCE(MATCH_REGEXP(T1.'Test Execution Status',"(?<=FAIL: )\d{1,4}","g"),0) as 'Fail',
COALESCE(MATCH_REGEXP(T1.'Test Execution Status',"(?<=DESCOPED: )\d{1,4}","g"),0) as 'Aborted/Descoped',
COALESCE(MATCH_REGEXP(T1.'Test Execution Status',"(?<=BLOCKED: )\d{1,4}","g"),0) as 'Blocked',
COALESCE(MATCH_REGEXP(T1.'Test Execution Status',"(?<=ABORTED: )\d{1,4}","g"),0) as 'Aborted/Descoped',
Test Plan Status:
COALESCE(T1.'Test Plan Status',T1.'Testausführungsstatus') AS 'Test Execution Status',
COALESCE(MATCH_REGEXP(T1.'Test Plan Status',"(?<=PASS: )\d{1,4}","g"),0) as 'Pass',
COALESCE(MATCH_REGEXP(T1.'Test Plan Status',"(?<=TODO: )\d{1,4}","g"),0) as 'Todo',
COALESCE(MATCH_REGEXP(T1.'Test Plan Status',"(?<=EXECUTING: )\d{1,4}","g"),0) as 'Executing',
COALESCE(MATCH_REGEXP(T1.'Test Plan Status',"(?<=FAIL: )\d{1,4}","g"),0) as 'Fail',
COALESCE(MATCH_REGEXP(T1.'Test Plan Status',"(?<=DESCOPED: )\d{1,4}","g"),0) as 'Aborted/Descoped',
COALESCE(MATCH_REGEXP(T1.'Test Plan Status',"(?<=BLOCKED: )\d{1,4}","g"),0) as 'Blocked',
COALESCE(MATCH_REGEXP(T1.'Test Plan Status',"(?<=ABORTED: )\d{1,4}","g"),0) as 'Aborted/Descoped',
but the above doesnot work anymore in confluence cloud and i am forced to use manual test plan/test execution dump from xray reports which is cumbersome and not LIVE statuses..
Can someone please help me with this?
Thanks,
Arijit Chatterjee
