Advanced query help.

Question

Hello,

I started working for a company that has a terrible Jira structure. I have some old queries that work everywhere else I go. I have planned to done. So I query a sprint and I can see what was planned, completed, and not done. It's similar to the canned sprint report but better.

They have one project

Multiple teams working in the same project with each having their own sprint.

I almost get there but it's just not easy.

So my query would need the project of course, board name which is typically the team doing the work. sprint stat date and all the stories on that date in the to do status, sprint end date and any story in any status other than done..

Any Ideas?

dan_marcantel · Answer

years ago on premise you could. that query you have is my basic query and then i add a little more.

I am going to try tableau or something else

Rachel Wright · Answer

Hi @dan_marcantel ,

I don't think you can access sprint start and end dates with JQL.  There's a request for that in Jira Server that you can vote for here: https://jira.atlassian.com/browse/JSWSERVER-13029

In the mean time, can you leverage a query like this?

project = project-name and sprint = sprint-ID and type = story and status != done

You'll need to fill in the bold items with your own unique values, of course.

Hope this helps!

Rachel Wright
Author, Jira Strategy Admin Workbook