Test Execution status and Test Plan Status is not working which was working in server edition.

[arijit chatterjee]

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

[Jayesh Raghuvanshi]

@arijit chatterjee 

Confluence Cloud does not support direct SQL-like queries or advanced regex queries inside content pages like the ones you used for Test Execution and Test Plan Status in Server. Cloud limits macros and queries to JQL (Jira Query Language) or predefined report macros.

Use Xray Cloud's built-in reports and gadgets that provide run-time status updates.

Reference artices

https://support.atlassian.com/confluence-cloud/docs/insert-the-jira-issues-macro/


Thanks
Jayesh R

[arijit chatterjee]

But is test execution status and test plan status atleast exposed by Atlassian in cloud or that also is not exposed. Please can you confirm. 

[Jayesh]

@arijit chatterjee 

Yes, test execution status and test plan status are exposed in Atlassian Cloud via Xray Cloud’s APIs, specifically the GraphQL and REST APIs. These statuses are not accessible through direct SQL-like queries or regex parsing within Confluence Cloud pages as they were in Server Edition

[arijit chatterjee]

Got it.. Thanks much..