Hi,
Can someone help me to get a SQA query for extracting all issue types from JIRA DB pls. I want to know how many total issue types are there in server.
Regards,
Nirmalya
Hello,
As a mater of fact, you can't extract all issue types from a JQL query.
However, you can extract all issues from your Jira instance, and then using Excel to analyse the obtained file
Best solution is to go to Admin -> Issues -> Issue types and read the page.
With SQL, you're going to have to faff around joining tables and you shouldn't really have any access to the database at all if you're looking after it properly.
Hi @Nirmalya Mohapatra
For informational purposes,
select pname from issuetype
would give all issue type names
select count(*) from issuetype would give you count
Hope this helps
Thanks
Chander Inguva
Thanks all for your valuable suggestions..
SELECT i.id issuetype_Id, i.pname issue_name, COUNT(*) num_of_issuesFROM jiraissue jJOIN issuetype i on j.issuetype = i.IDGROUP BY i.idORDER BY num_of_issues DESC;
This will get all issue types and the number of issues in them
It looks like you're new here. Sign in or register to get started.
