Filtering tasks on ongoing sprints

Jary Nubla October 8, 2024

How can I filter for tasks in ongoing sprints from different projects? I read about current()  and tried using it 

project IN (LOC, PROD) and Sprint in current()

but it's saying  'current' is a reserved JQL word. You must surround it in quotation marks to use it in a query. (line 1, character 98)

openSprints() shows all tasks that are already in sprints even if that sprint has not yet started. I only want to see the tasks in the ongoing sprints.

2 answers

1 accepted

1 vote
Answer accepted
Guanglin Zhang (XDevPod)
Atlassian Partner
October 8, 2024

I tried to generate the JQL with "AI for Jira" app, you can try it: 

sprint in openSprints() AND NOT sprint in futureSprints()

jql1.png

Jary Nubla October 8, 2024

Thanks so much, that worked! I'll check out that app as well, thanks for the reco :)

0 votes
Ollie Guan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 8, 2024

Hi @Jary Nubla ,

sprint in openSprints ()
Jary Nubla October 8, 2024

Hi Ollie, 

Thanks for your reply. But as I said above, openSprints() shows all tasks that are already in sprints even if that sprint has not yet started. I only want to see the tasks in the ongoing sprints or sprints that has already started.

Can you help me on this? Thanks in advance :) 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events