Quickfilter to not show Sub-Tasks that were resolved in a previous sprint

[stephan_lewis]

I'm trying to create a Scrum Board Quickfilter to not show sub-tasks that were resolved in a previous sprint.

I was able to create a filter that returns all the sub-tasks that have been closed in previous sprints.

issuetype in subtaskIssueTypes() AND resolved <= endOfDay(-1d) AND sprint in closedSprints()

I need to find the opposite (show everything but ...)

I tried various NOT and != but without any success

Any ideas?

[stephan_lewis · Accepted solution]

I had to make it a bit more complicated 

First - include all the Standard Issue types.

Second - remove all the sub-tasks that were carried over from previous sprints.

Third - add back in sub-tasks that haven't been completed in the current sprint.

issuetype in standardIssueTypes() OR issuetype in subtaskIssueTypes() AND NOT resolved <= endOfDay(-1d) AND sprint in closedSprints() OR issuetype in subTaskIssueTypes() AND statusCategory != Done

[Carla Ann Rowland]

you need to do:

issuetype in sub-taskIssueTypes()  AND resolved<=endOfDay(-1d) AND sprint in currentSprint() 

this should display only sub-tasks in current sprint. 

[stephan_lewis]

That is what I said - I want to show everythng but sub-tasks that have been resolved in previous sprints.

[stephan_lewis]

Also I get the message "Unable to find JQL function 'currentSprint()'

Is that a Scriptrunner command? If so I'd have to use ScriptRunner and then call that filter.

[Carla Ann Rowland]

It might be a Scriptrunner function; I make it a standard part of a configuration of the instance I work in.  Opensprint () and Issuetype in subtaskIssueType() might work