Query projects in cloud

[Sue Hannan]

Looking for a query that will pull all the projects using a particular custom field

[Shalini Pradhan]

Hello @Sue Hannan ,

Good day! Welcome to Atlassian Community :)

In Jira cloud, JQL doesn't have a direct way to query projects that are using a specific custom field because custom fields.

However you can use following queries:

• JQL: "Custom Field Name" is not EMPTY
  This will fetch all the issues where a particular custom field is set
• JQL: project in (project1, project2) AND "Custom Field Name" is not EMPTY
  This will fetch all issues where the custom field is not empty within the specified projects

You can also navigate to settings -> Work items -> Custom fields and search for your required custom field and click the project link under project column and you would see the list of projects, the custom field is using

Hope that helps!

[Aaron Williams]

Hey @Sue Hannan 

Without have to make a number of API calls you could do a couple of things of the top of my head. 

1. JQL: "name of field" IS NOT EMPTY - this will return all tickets where the field has been used. If it's not too many you could count the different project keys.

2. If you go to the "work items" section from the cog, go to custom fields, search your field and it tells you how many projects it's used in, and if you click the link you'll see the projects.

Someone may know some better ways without numerous API calls. 

Thanks

Aaron.