You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This documentation aims to guide our customers in checking the amount of data they have for each Xray issue type. It also helps assess the size of their Jira instance, providing insight into the volume of data to be migrated to the Cloud.

select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname='Test';


select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname in ('Test Execution', 'Sub Test Execution');


select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname='Test Plan';


select count(*) from "AO_8B1069_TEST_RUN";


select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname in ('Test Execution', 'Sub Test Execution');


select count(*) from jiraissue j join issuetype as it on (it.id=j.issuetype) where it.pname='Test Plan';
select count(*) from "AO_8B1069_TEST_RUN";


For the attachment, please check: How to get Xray Attachments size info on Jira Data Center?



  • No labels