You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I am searching for a means, preferably jql, to find all issues in a project that are in more than one sprint. Whether open sprints, closed sprints or future sprints - if there is more than one sprint associated with the issue I'd like to query to find it.
Maybe this is beyond the scope of jql and there is a plug-in to find it or I will need to write sql to do so.
Assuming your sprints are incrementing in a sort (ie. Sprint 5, Sprint 6, etc... although this may work just based on Sprint ID rather than sprint name (I'm not sure how JIRA sorts)) you can do something like this:
status != Done AND sprint in closedSprints() AND sprint in openSprints() ORDER BY Sprint ASC
Make sure the sprint column is showing and you'll see the tickets that have been dragging the longest at the top of the results (because they belong to the oldest sprint).
A colleague at our organisation came up with this simple yet elegant board filter
issueFunction in previousSprint(<board number>) AND sprint in openSprints()
So - I have the same question, and here's a 'poor man's' way to get to the information. In my case I wanted to see all issues closed in the previous release and then determine how many of those issues took more than one sprint to close.
I created a query that met the criteria (in the last release, closed) and also included the Sprint column in the results. The Sprint colu,mn includes all sprints that each issue was in, separated by commas.
I exported the results to Excel.
In my case I just wanted to count the sprints per issue, so in Excel, I split the Sprint column into separate columns by the comma delimiter.
Then I was able to filter on the split sprint columns to see how many issues took 2 sprints, 3 sprints, etc.
Tedious, but not as tedious as counting by hand.
select distinct count(cv.issue), p.pkey, ji.issuenum from customfieldvalue cv inner join customfield cf on cf.id = cv.customfield and cf.customfieldtypekey='com.pyxis.greenhopper.jira:gh-sprint' inner join jiraissue ji on ji.id = cv.issue inner join project p on p.id = ji.project group by cv.issue, p.pkey, ji.issuenum having count(cv.issue) > 1
This should give you a start - it ran on my instance and reported as expected.