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.

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

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

[Dave]

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

[hesam]

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]

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()

[Shilpi Marwah]

thanks this was helpful

[Hernan Halabi - Elite IT Consulting Group · Accepted solution]

Hello @Janine_Memon  a query like this should work

sprint in openSprints ()

[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.

[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]

thank you, that worked for me

[Roman_Bozeman]

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

[Janine_Memon]

Thank you!