nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Queries issues currently assigned in a sprint

Karim Masarweh

Hi All

I'm trying to query something that I believe should be very simple: "Find stories CURRENTLY assigned to a sprint" or in other words, ignore the backlog.

I tried using this JQL: "issuetype = Story and sprint is not empty".

However, I noticed that a specific issue ABC-123 is not returned in the results even though it's currently showing like this in the UI "Sprint: None [+1]"

So what I understand is that, even though ABC-123 has currently a none sprint, the fact that it was assigned in the past in a sprint and taken out to backlog, it still comes back in the query...

How can fully ignore the backlog?

Thank you in advance.

Accepted answers

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

The sprint field is not as simple as just "current sprint", it needs to contain all the sprints an issue has been through, so that you can report on old and current sprints (but not the sprints that have not been started)

You need to use the functions to do this. Try

sprint in openSprints()

There are two others you might find useful in the future - futureSprints() and closedSprints()

All comments

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

You need to use the functions to do this. Try

sprint in openSprints()

There are two others you might find useful in the future - futureSprints() and closedSprints()

Karim Masarweh

Thanks Nic for the answer.

I'll be trying that.

It's just so mind boggling how a very basic need is not answered in a simple query.

I looked also for a way to find that backlog. Apparently there's a need for a complex JQL there as well. Such a complex JQL for such a basic query in Agile processes...

If you're from Adaptavist, I hope you will come with some functions to make this easier 😉

Thanks again

Nic Brough -Adaptavist-

The thing here is that your board automatically provides that basic need, it's what boards are for.

The best Adpatavist could do is duplicate the function for "sprint in openSprints()"

Karim Masarweh

Understood.

Any idea how to find those in the JIRA API?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software-cloud