Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Pull data from a Jira Project

Hello,

I am new to Jira and still learning how to use the system. I have been tasked with a job that I am not sure how to complete.  The user wants me to figure out how we can pull all the data for tickets created in a project. They want to be able to search for specific items in the data by some short tagging system.

Steps I have taken so far

  1. Filters > Advanced Issue Search
  2. Changed the 'project' to the name of the project the data needs to be pulled from
  3. All the issues/tickets/whatever you call them to load from the project
  4. Click on the excel icon on the top right
  5. Opens the report in excel and I download the Jira plugin

This is where I am stuck. It is only showing me the issue I had in step 3 but I need to be able to gather all the data from each one.

Also, how can I get the right tagging system so the user can pull specific data?

Thank you for the help :)

2 answers

in order to get all of the issues to go into the Excel spreadsheet, you need to be using the List View.  When you use the Detail view, one issue is selected and that is the only issue which will display in the excel spreadsheet.


you should be using various custom fields for the data in addition to the system fields.  In the Advanced view, Jira Quey Language is used to retrieve issues based on selection criteria.

Hi Michael,

When I am in the project under "Advanced Issue Search" I am using List View in Jira and not Display View. 

Can you please explain what you mean in more detail about your second suggestion?

Hi @Tyson Dover  -- Welcome to the Atlassian Community!

I am unclear what you mean by "tagging system".  Would you please explain that term?

And, when you note that you do not get all the data, what do you mean?  Are you only getting some of the fields or only some of the issues you expect?

To help you get started:

  • In the advanced issue search, you may use the Basic search (with the drop-down values) or use Switch to JQL to enter your query directly
  • Note at the right of the page, there is a Columns list.  You may select which fields you want to see there.
  • Once you have a filter you like, you can save it for re-use
  • You note selecting the Excel icon to get the results.  You may also select the Export drop-down list at the top right of the page to get data in other formats, including Comma-Separated Values (CSV), which spreadsheets can also open.  With CSV, you may export just the fields shown on the page, or all of the fields.


Best regards,

Bill

Hi Bill,

Tagging system is what the person who wants the excel kept on saying. I think she means by being able to bring up individual issues by how they are tagged. 

By not getting any data I am only able to see the project details but nothing else. If you were on Jira and you saw an issue you would click into it to see all the detail. I am only seeing on excel the issue title and nothing else.

Hi Tyson,

Would you please provide the query you are using, and a screen image of the results?  That may help the community give you suggestions.

Thanks!

Hi Bill,

Here are the screen shot you asked for. I had to black out most of it because of security reasons but you should still understand what I am trying to do.

From Jira I bring up the Project which I see all the issues, then I click the excel button in red.

1.png

then excel I get this but it just show the issues list from Jira but no data per the issue.

2.png

 

The data in each issue looks something like this and I want to be able to have the columns highlighted in red to be filtered in excel for all the issues in the project.

3.png

Thanks for the images!

Earlier I noted to look at the right of the issue search page, there is a Columns selector.  You may select which fields you want to see there.  Use type-ahead search to target in on what you want.  Once the fields are displayed on the page, try your export again.

Also note that once it looks as you wish, select Save As at the top of the page to save your filter and field column configuration.  You may then easily reuse it in the future by selecting it from the Filters list.

Hi Bill,

Thank you for your response. I see now the issue is the tables from the tickets are actually from Microsoft Forms and are just pasted into Jira as text. That is why I am not able to see the columns. Now I have to figure out how to get data from MS Forms > Jira > Excel. Any ideas? lol 

Hmmm... I am guessing that is some type of mark-up pasted into the description field.  Without a market place add-on I think you are going to need to use Excel formulas to extras the values into individual spreadsheet columns.

It may be convenient to paste a table into a field like Description, and then it causes later problems when you want to report on the information.

Two work-arounds could be (if this is your long-term plan to use Description), are:

  1. Create custom fields and put the data those fields rather than in Description
  2. Create custom fields, continue to paste into Description, and write automation rules to parse the information into the custom fields whenever the Description changes.  This approach could be brittle (maintenance heavy) if you plan to change the layout of Description tables often.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you