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>') |
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>') |
Impact on Xray Issue Links
...