SQL query for extracting all issue types from DB

[Nirmalya Mohapatra]

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

[Babs Adewole]

SELECT i.id issuetype_Id, i.pname issue_name, COUNT(*) num_of_issues
FROM jiraissue j
JOIN issuetype i on j.issuetype = i.ID
GROUP BY i.id
ORDER BY num_of_issues DESC;

This will get all issue types and the number of issues in them

[Nirmalya Mohapatra]

Thanks all for your valuable suggestions..

[Chander Inguva]

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

[Nic Brough -Adaptavist-]

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.

[Guilhem Dupuy]

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