How to export all project names with a specific field in JIRA

Trying to export all project names with a specific field.  How?

3 answers

In the "Search for Issues" screen, there's a button called "Columns" on which controls what fields are to be displayed in the results. Uncheck everything that you don't need and then choose the option "Export (Current Fields).

What I don't understand however, is what you mean by "No issues to be exported, just the business area field information". Custom Fields are associated to issues, so you will have to export the issues with these custom field.

The export data we are looking for is just 2 data elements. - 1. Project name 2. business area impacted from the issue, not the issue itself.

So, you want to get one row per each issue, but you just want to display two columns: the 'Project' the issue belongs to, plus the value of the custom field 'business area impacted'. Is that accurate?

I don't think that's the requirement. To me, it sounds like a simple list of projects. Not issues, not the value of the custom field (because that's on issues, not projects)

Yes, no issues. I can't comment because I don't have 25points

0 votes

What do you mean by "with a specific field"?

We have a field we use "business area impacted" we use for issues.  I wanted to extract the project name and only the business area impacted for issues.  - No issues to be exported, just the business area field information.

Ok, you can't do it, because JIRA works with issues, not projects. You can get close though. Filter for *"business area impacted" is empty*. Save the filter. Put a gadget on your dashboard called "filter statistics", selecting your saved filter, and "project" as the field to group by. You'll get a list of all projects that have issues using the field at least once. It won't list projects where the field *could* be used, but has not yet been used, and you'll have numbers on the graphs to tell you how much the field is actually used as well, but it should cover most of what you need there.

You can use JIRA gadgets on Confluence pages. That's the closest you'll get

How many projects do you have ? If you need only project names, go to ->all projects, and select all page content using mouse drag, copy and poste on excel sheet. You may have to remove unwanted data like, project lead, key etc.

That screen does not tell you whether a project is using a field or not.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Jan 08, 2019 in Jira

How to Jira for designers

I’m a designer on the Jira team. For a long time, I’ve fielded questions from other designers about how they should be using Jira Software with their design team. I’ve also heard feedback from other ...

875 views 3 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you