How do I create a filter that shows the active Sprint with its issues and subtasks that I can export

[Nancy Corsi]

On the search for issue  I want to create a filter that allows me to see an active sprint, including the issues and bugs.

[Mikael Sandberg · Accepted solution]

Hi @Nancy Corsi,

Welcome to Atlassian Community!

project = JRA AND sprint in openSprints() will give you all issues that are associated with the current active sprint.

[Nancy Corsi]

Hi thank you. I copied and pasted the formula and changed JRA to my projects name but received the following error...Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'will'. (line 1, character 43)

[Nancy Corsi]

I figured it out

[Nancy Corsi]

It works perfectly!

[Nancy Corsi]

What can I add to the formula to  NOT include the subtasks?

[Mikael Sandberg]

project = JRA AND sprint in openSprints() AND issuetype != sub-task will remove subtasks from the result.

[Nancy Corsi]

Works!