Page History
...
Can I know the progress of archiving or restoring Xray entities when archiving or restoring the Project?
When a project is archived or restored, Xray kicks in to archive or restore its data (for example its Test Runs). The latter can be a long running task depending on the amount of Xray data to handle.
Currently there is no easy way of knowing the progress of it. But in case you need to know the overall progress, you can refer to the below queries which will report the number of active/archived entities.
On Project archive:
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 project 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>') |
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
--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 project 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>') |
Contact
Can I send you guys an email?
...