Search code examples
jirajira-pluginjqlpython-jira

JQL to retrive specific columns for a cetain label

I have limited experience with Jira and Jira query language.

This is regarding JIRA Query language. I have a set of 124 rows (issues) in Jira that are under a certain 'Label' say 'myLabel'.

I need to extract columns col1, col2 and col5 for all of the above 124 rows where the Label field is 'myLabel'.

Once I have the above result I need to export it to an excel sheet. Is there a JIRA query that I can fire to do this ?

Or Is there some other way that this can be done, like maybe exporting all of the 124 rows with all the n columns to a SQL table and then doing an SQL query on top of it to retrieve the results that is needed ?

Also there is something python-jira. Can that be of some help ?

Solution

  • Here's how to get issues by label via an http GET:

    http://yourserver.com/rest/api/2/search?jql=labels%20%3D%20SearchString

    Replace "SearchString" with the label you want to search for. This will return you a JSON object with a (JSON) array of issues.

    I am more familiar with the Java API than the python one, but I imagine it should be pretty easy to to take the JSON array and put it into an excel sheet (or into a CSV file that excel will play nicely with).