nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter for projects using an issue type

Sravan Kumar_wfhjdm

Hello,

is there a way to get the list of projects that are using the issue type "Feature" in my case, by using the JQL?

Thanks!

Accepted answers

DPKJ

@Sravan KumarJQL is used just to fetch list of issues. If doesn't return list of projects or for that matter anything other than issues.

Now to get list of project that is using 'Feature' issue type you have three ways,

Find all Issue Type Scheme associate with 'Feature' issue type and later find projects in those Issue Type Schemes.
- Link for this here - https://confluence.atlassian.com/adminjiraserver/associating-issue-types-with-projects-938847092.html
Run an SQL query in your database and find list of project.
- ```
SELECT DISTINCT P.pname, P.pkey, P.lead AS project
FROM project as P
INNER JOIN jiraissue as J on J.PROJECT = P.ID
INNER JOIN issuetype as I on I.ID = J.issuetype 
WHERE J.issuetype= <ID_OF_FEATURE_ISSUE_TYPE
```
- You can ID_OF_FEATURE_ISSUE_TYPE from Jira UI, for that visit "Administration"-> "Issues"->"Issue Type" and go to 'Feature' issue type and click 'Edit' and issue type ID will be in your browser address bar,
- Some thing like, <BASE_URL>/secure/admin/EditIssueType!default.jspa?id=<NUMBER>
- Here <Number> is id of issue type.
Use rest API to get this information.
- You can use issue create meta api referenced here - https://docs.atlassian.com/software/jira/docs/api/REST/8.0.0/#api/2/issue-getCreateIssueMeta
- Also you can find some usage of this API on this page - https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/ in `Getting metadata for creating issues examples` section.

Like and accept if this helps.

All comments

DPKJ

@Sravan KumarJQL is used just to fetch list of issues. If doesn't return list of projects or for that matter anything other than issues.

Now to get list of project that is using 'Feature' issue type you have three ways,

Find all Issue Type Scheme associate with 'Feature' issue type and later find projects in those Issue Type Schemes.
- Link for this here - https://confluence.atlassian.com/adminjiraserver/associating-issue-types-with-projects-938847092.html
Run an SQL query in your database and find list of project.
- ```
SELECT DISTINCT P.pname, P.pkey, P.lead AS project
FROM project as P
INNER JOIN jiraissue as J on J.PROJECT = P.ID
INNER JOIN issuetype as I on I.ID = J.issuetype 
WHERE J.issuetype= <ID_OF_FEATURE_ISSUE_TYPE
```
- You can ID_OF_FEATURE_ISSUE_TYPE from Jira UI, for that visit "Administration"-> "Issues"->"Issue Type" and go to 'Feature' issue type and click 'Edit' and issue type ID will be in your browser address bar,
- Some thing like, <BASE_URL>/secure/admin/EditIssueType!default.jspa?id=<NUMBER>
- Here <Number> is id of issue type.
Use rest API to get this information.
- You can use issue create meta api referenced here - https://docs.atlassian.com/software/jira/docs/api/REST/8.0.0/#api/2/issue-getCreateIssueMeta
- Also you can find some usage of this API on this page - https://developer.atlassian.com/server/jira/platform/jira-rest-api-examples/ in `Getting metadata for creating issues examples` section.

Like and accept if this helps.

Nic Brough -Adaptavist-

The simplest way to do this is run

issuetype = feature

save it as a filter. Give it a good name, then go to your dashboard and add a new gadget for "filter statistics". Use

Filter: the one you saved
Include resolved issues: yes
Statistic: Project

This won't tell you every project that might use it, but it will tell you the ones that are.

Muhammad Ramzan_Atlassian Certified Master_

@Sravan Kumar , if you are Jira admin, then you can go to Jira administration > issue type schemes.

If a issue type is associated to a project, it means its used in that project.

Sravan Kumar_wfhjdm

Thanks @Nic Brough -Adaptavist-

I thought about this too but the downside is it is not giving me all the projects as you mentioned. Thanks anyway!

Sravan Kumar_wfhjdm

I'll give it a try for solution:2 using the SQL query from the database. Thank You!!

Brian Mertens

Thanks, @Nic Brough -Adaptavist- . This works perfectly when looking for projects that actually use the issue type. In my use case, I didn't want projects that might use it because we have many projects that include issue types in their issue type scheme but they never get used. Thanks!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

jql