Page History
...
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. Replace <PROJ_KEY> with the project key. 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 = '<PROJ_KEY>' OR p2.pkey = '<PROJ_KEY>') --The below query returns the number of active tests in test repositories and test plan boards. Once it reaches 0, all tests where successfully hidden. Replace <PROJ_KEY> with the project key. SELECT count(*) as active_tests FROM "AO_8B1069_LEAF" leaf JOIN jiraissue test on test.id=leaf."TEST_ID" JOIN project p1 on p1.id=test.project WHERE (leaf."ARCHIVED" = 'N' or leaf."ARCHIVED" IS NULL) AND (p1.pkey = '<PROJ_KEY>') --The below query returns the number of archived test runs in the project. Once it reaches 0, all test runs where successfully restored. Replace <PROJ_KEY> with the project key. 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 = '<PROJ_KEY>' OR p2.pkey = '<PROJ_KEY>') --The below query returns the number of archived tests in test repositories and test plan boards. Once it reaches 0, all tests where successfully restored. Replace <PROJ_KEY> with the project key. SELECT count(*) as archived_tests FROM "AO_8B1069_LEAF" leaf JOIN jiraissue test on test.id=leaf."TEST_ID" JOIN project p1 on p1.id=test.project WHERE (leaf."ARCHIVED" = 'Y') AND (p1.pkey = 'DOC<PROJ_KEY>') |
Impact on Xray Issue Links
...