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

I want to pull a report of explicit ticket numbers and status

I have a list of tickets in a particular project board. I want to pull the information (ie status, priority) for just these specific tickets. I know how to export to CSV after the search is made.

 

Thank you in advance. 

1 answer

0 votes

Hi @Sahil Verma 

You mean you just want these two fields in the export? In that case create a filter with only 2 columns with these fields and export CSV (Current fields).

Let me know if this is what you want to do.

Ravi

@Ravi Sagar -Adaptavist- Hi Ravi, I have a list of tickets in a spread sheet for example. I want to insert the ticket numbers in one go and then pull the CSV, how do I do this? 

Hi @Sahil Verma 

Not sure if I understood correctly. You have a list of Jira issues in a spreadsheet and you want to pull other fields from Jira? If this is the case you need to use Jira REST API and write a macro (VBA in Excel or Google App Script in Google Spreadsheet) to pull the data from Jira.

or

If your issues are part of filter then you can use url like this to retrieve the CSV and use it as data source in your spreadsheet (Excel)

JIRA_URL/sr/jira.issueviews:searchrequest-csv-current-fields/10100/searchrequest-10100.csv

Replace the number with your filter id.

Let me know if this is what you were looking for?

Ravi

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

888 views 7 24
Read article

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