JQL for broad based queries

[Peter Jones]

Hi,

I am driving some improvement work in teams who use a reasonably large JIRA installation. We currently have over 600 projects containing more than 12k open / in progress tickets (our lifetime total of tickets is over 400k ).

To understand behaviours I would like to extract some data from the tool and am finding much of it very difficult to export.

My current quest is to understand how many sprints had defined Sprint Goals and perhaps to review the quality of the same. Any suggestions?

Also, a list of boards would be very helpful (to understand which are owned or administered by people who have left the firm).

These topics really are at the "back end" of the development process. They're not at all fun.

Are there any tools than can help with this stuff?

Pete

[Clark Everson]

Hi Pete,

For these types of things it's very much manual work there isn't really a way to look it up natively with Jira to report off of. You would need a third party tool for dashboarding or reporting such as easy BI: https://community.eazybi.com/t/sprint-goals-for-current-sprints/7037

Or utilizing the rest API. When you are trying to comb through a lot of data generally the rest api or external tools are better. This is because via the API and in some cases SQL rather than JQL and then displaying in the rest API you can set limits on the scripts about how quickly the data is pulled in order to not slow down the Jira instance. Via the UI though, these functions are already built in, such as 1000 issues displayed at a time, or if queries are too complex they will error out

For API related tasks though you may get some answers here but the Developer Community will be better: https://community.developer.atlassian.com/

Best,

Clark

[Peter Jones]

Hi Clark,
Thank you for taking time to reply.

We've already explored the API. Whilst we can extract more information than we can using JQL there are still some bits we can't extract (such as a list of boards).

I guess the answer is that this will be a manual process.

I will take a look at EasyBI, thank you for that.

Pete