JQL query to know the stories that have been modified after the story status moved to "ReadyToRele"

[neelam annad]

JQL query to know the stories that have been modified after the story status moved to "Ready To Release" or Accepted.

I am writing the below query -

project = "xxxxx" and "IssueType" = story and status changed TO ("Ready To Release")  and sprint not in openSprints() and updatedDate is not EMPTY

But want to add another condition updatedDate > sprintEndDate

didn't find the columnname which indicate the SprintEndDate

[neelam annad]

Sorry for reply late, we are using Jira 3 and I didn’t find any custom field related to releaseDate added

[John Funk]

Hi @neelam annad  - You cannot compare two date fields in stand JQL. You would need to compare each date field to a range of values (like created >= 2019-12-01 to see issues created on or after December 1st). 

[John Funk]

Why are you trying to use releaseDate? You might could use: "Release Version History" = latestReleasedVersion()

[Zita Bagi]

Hi,

I have found that this isn't actually possible:

https://community.atlassian.com/t5/Jira-questions/How-to-display-sprint-Start-End-Date-in-the-issue-filter-columns/qaq-p/828473

There are some similar workarounds though

https://community.atlassian.com/t5/Jira-questions/How-can-I-get-the-Sprint-s-Start-and-End-date-in-JQL/qaq-p/110425