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

[Deleted user]

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

[Prakhar Srivastav _Appfire_]

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]

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

[Deleted user]

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.