Filtering tasks on ongoing sprints

[Jary Nubla]

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.

[Guanglin Zhang (XDevPod) · Accepted solution]

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

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

[Jary Nubla]

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

[Ollie Guan]

Hi @Jary Nubla ,

sprint in openSprints ()

[Jary Nubla]

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