advanced filter to search sprints bigger than

[Mick van Breukelen]

Since 2 sprints ago we are working with a new method (please don't ask)

I want my reporting to be about all the sprints SINCE this new method.

So, basically:

Sprint >= "EV Sprint 38"

At least, all sprints with 38+ numbering.

How to filter this way in Jira SQL? (instead of adding a new sprint to the filter, every 2 weeks)

[Jack Brickey · Accepted solution]

Hi Mick, as you have found > operator is not a supported option. Moreover you can’t leverage sprint start/end dates which would be able to accomplish your goal. There is a feature request you might watch - JRACLOUD-72007 .

you might consider looking at an addon, e.g. Scriptrunner.

[Mick van Breukelen]

"Not possible" is also an answer.

Thank you. I have voted on that issue and have also created a new issue that would properly solve my issue.

https://jira.atlassian.com/browse/JRACLOUD-74761 , if you're interested.

[Michael Tarleton]

I looked in the ticket above and noticed there is a workaround that may work:

statusCategoryChangedDate >= -2w

[Mick van Breukelen]

I forgot to mention that the >= doesn't work.

I've tried it and got this message: "The operator '>=' is not supported by the 'Sprint' field."