export JQL query output to CSV file

[sneha priya]

I need to fetch JQL query output to CSV file .I want only selected fieds (which I am querying)

without applying 'filter' option available in jira tool and without using any plugins.

[Bastian Stehmann · Accepted solution]

Hi @sneha priya,

welcome to this community.

What do you mean with "without applying filter option"? You can export the issues when you search for them, there is an export button on the right above your query.

If you do not want to do this, where in Jira do you want to do that export?

[sneha priya]

Thanks @Bastian Stehmann  

I am aware of export button available on the jira tool . But my concern is to export only few fields into the CSV file.

And for choosing those fields I don't want to use filter button or any plugin.

Is there any other way like writing JQL query ,which will directly copy the resultant output JQL query in a CSV file.

[Bastian Stehmann]

Can you tell me, why using the filter button is no option for you?

Anyway, here is a suggestion with Jira Command Line Interface:

https://community.atlassian.com/t5/Answers-Developer-Questions/How-to-export-issues-to-csv-file-programmatically/qaq-p/553755

Maybe this is an option for you.

[sneha priya]

@Bastian Stehmann

I have to train a model based on some fields , I want to feed 2 CSV files containing all those fields into the model.

But we have to get this data file from some of our clients. So we can't expect them to select all those columns one by one and give us their data set to us. 

They are demanding for some query kind of thing or any other easy way to access all those columns I want

[sneha priya]

@Bastian Stehmann

I already went through the above link earlier . I was unable to understand what Nic Brough was saying about writing a report or issue view. 

[Bastian Stehmann]

Ok, but you know, that your customers would have to select the columns only once, when they then save the filter, the columns can be saved also.

If that is no option, maybe it is an option to export all fields and you do the selection when/before importing the data into your model.

Nic meant to develop a new report (that would be in the reports section then), but that's like developing a new add-on. If you do that, you can just give that add-on to your clients.

I meant the last post in that question from Bob Swift, but I think that will only work if exporting all fields is an option.

[sneha priya]

Hi @Bastian Stehmann  

Thanks for update :)

But I need not only fields but also count of all those fields (I came to know that we can't fetch it with JQL alone) .For example: columns like count of issues at start time , count of issues to do, velocity at start time , velocity difference , count of issues added  , total velocity added for a all sprints .

Lately I came to know that JQL needs to be used through REST API

https://community.atlassian.com/t5/Jira-questions/How-to-get-issue-count-using-JQL-in-jira/qaq-p/498188

[sneha priya]

@Bastian Stehmann

Thanks for your time :)

I am using Jira Python now. 

[Alexey Matveev]

Hello,

Go to the Issue Navigator (Issues -> Search for Issues). Enter you JQL query. Then choose Export -> CSV (Current fields)

[sneha priya]

Hi,

Problem with Current field is that it does not contain all those fields which I want to export in CSV file

[Payne]

You can add columns to the display by clicking the Columns button in the upper right corner, and export current view then includes all of the columns that are displayed.

[sneha priya]

Hi @Payne I have mentioned it earlier only that I can't use filter option available in Column button