Page History
...
Currently, Jira provides no way of knowing the progress of a project archival blablablablabla TODO
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
--The below query returns the number of non-archived test runs in the project. Once it reaches 0, all test runs where successfully archived
SELECT count(*) as active_test_runs
FROM "AO_8B1069_TEST_RUN" tr
JOIN jiraissue exec_issue on exec_issue.id=tr."TEST_EXEC_ISSUE"
JOIN project p1 on p1.id=exec_issue.project
JOIN jiraissue test_issue on test_issue.id=tr."TEST_ISSUE_ID"
JOIN project p2 on p2.id=test_issue.project
WHERE (tr."ARCHIVED" = 'N' or tr."ARCHIVED" IS NULL)
AND (p1.pkey = 'DOC' OR p2.pkey = 'DOC')
--The below query returns the number of archived test runs in the project. Once it reaches 0, all test runs where successfully restored
SELECT count(*) as archived_test_runs
FROM "AO_8B1069_TEST_RUN" tr
JOIN jiraissue exec_issue on exec_issue.id=tr."TEST_EXEC_ISSUE"
JOIN project p1 on p1.id=exec_issue.project
JOIN jiraissue test_issue on test_issue.id=tr."TEST_ISSUE_ID"
JOIN project p2 on p2.id=test_issue.project
WHERE tr."ARCHIVED" = 'Y'
AND (p1.pkey = 'DOC' OR p2.pkey = 'DOC') |
Impact on Xray Issue Links
...