How can I search sprints with "Sprint start date" > [DATE]

Deleted user November 19, 2018

Hi,

I tried to use the operators ">"  , "~" but got error saying that these operators are not supported.

I tried also to filter according to Sprint name using Sprint =  or Sprint "~" but didn't get the required result

JIRA Version : V7.9.0

 

1 answer

0 votes
Prakhar Srivastav {Appfire}
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 19, 2018

Hi Gali F

 

To find issues from a specific sprint, you have to add one of the following to your JQL query:

sprint = ID
sprint in (1,3,4)

 

You have other sprint related functions like opensprints() , Closedsprints() .

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html

 

If you have Adaptivist scriptrunner in your instance then you get a lot issueFunction for powerful searching with respect to sprint start date etc.

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_agile

Regards

Prakhar

Deleted user November 19, 2018

Thanks Prakhar .

In need to filter all sprints that starts after YYYY-MM-DD 

or 

All sprint with Sprint name that starts / includes specific string....

 

Thanks,

Gali

Like # people like this
Deleted user April 5, 2022

Yeah the Adaptivist query functions don't allow you to access the "Sprint.Start_Date" or "Sprint.End_Date"(I know those are  not the specific names of the fields, but you get the idea)

what would really be useful is something like this

 

issueFunctionOf(sprint in closedSprints() and Sprint.Start_Date >= X and Sprint.End_Date <= Y) 

That way you could capture items for Sprints that closed between 2 different dates.

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events