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; } } }

JQL to display what the current sprint is

Janine_Memon

How would I write a simple Query that would display the Active sprint? I.e. if we are in Sprint 5, I would "Sprint 5" to be displayed.

Accepted answers

Hernan Halabi - Elite IT Consulting Group

Hello @Janine_Memon a query like this should work

sprint in openSprints ()

Jack Nolddor [Sweet Bananas]

Hi Janine, note that JQL is about issues and you cannot retrieve other data than a list of issues using this language. JQL It is not SQL.

Using Advanced search features you can type the following:

 project = MyProjec AND sprint in openSprints ()

to retrieve a list of issues under your current Sprint of project 'MyProject'

Regards

All comments

Hernan Halabi - Elite IT Consulting Group

Hello @Janine_Memon a query like this should work

sprint in openSprints ()

Jack Nolddor [Sweet Bananas]

Hi Janine, note that JQL is about issues and you cannot retrieve other data than a list of issues using this language. JQL It is not SQL.

Using Advanced search features you can type the following:

 project = MyProjec AND sprint in openSprints ()

to retrieve a list of issues under your current Sprint of project 'MyProject'

Regards

Janine_Memon

Thank you!

Dave_cku7bl

This is not true. If you have a sprint with issues from multiple projects, this query only shows the issues from the project specified.

Roman_Bozeman

This function will break a jira gadget on a Confluence Page. Idk if it is all gadgets or just the Pie Chart.

Shaun Rucker

When I use 'spring in openSprints()', I am getting a bunch of backlog items (but not ALL) that have no sprint filled out. Has anyone else seen this? I checked the history, these items have never been part of a sprint, that I can see.

hesam_ezgdxj

Thanks for the answer. Works like charm. Just in case you want to filter everyone's else ticket use this JQL:

project = "YOUR_PROJECT_CODE" and sprint in openSprints() and assignee = currentUser()

Josh Carpenter_h33c25

This worked really well as a Quick Filter on a Kanban board. I also added a Quick Filter to the same board for "Exclude Current Sprint":

sprint not in openSprints()

Amy Christianson

I am seeing this, were you able to figure this out?

Shaun Rucker

It seems to have worked itself out...I have a query like this:
project = xxxx AND "Align Team" in (xxx, yyy) AND Sprint in openSprints() AND status = "Pending Approval"

This shows me the stuff that hasn't been approved to start yet but it's in the sprint. It works just fine. Not sure what 'fixed' it.

Jerome Fong_qq14ao

thank you, that worked for me

Eden Levy

Works for me!
Part of the team members cant see this filter
do you know why?

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

atl-orange