Is there a way to get a list of projects associated with all issuetypes?

Question

Hey,

Is there a way to get a list of all projects associated with all issue types?
For example:
Issuetype    Project Name
1. Bug          Project1
                    Project2
                    Project3.
2. Story        Project2
                    Project6
.

..

Thanks.

Chander Inguva · Answer

Hey @Rohith

- If you have access to backend (database), you can query using SQL like this

SELECT itp.pname, p.pname from issuetype itp
JOIN jiraissue ji ON ji.issuetype = itp.ID
JOIN project p ON ji.PROJECT = p.ID
GROUP BY itp.pname, p.pname
ORDER BY itp.pname ASC

Note: Above query is for SQL Server

Hope this helps

Thanks

Chander Inguva

DPKJ · Answer

You can this information via Jira Issue Create Meta rest API.

<jira_base_url>/rest/api/2/issue/createmeta

For more information on this look at `Discovering project and issue type data` section on this page https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/

And

Here - https://docs.atlassian.com/software/jira/docs/api/REST/8.3.2/#api/2/issue-getCreateIssueMeta