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 = '<PROJ_KEY>') |
...