Find issues where the due date is greater than release date

Januka Wijesinghe June 22, 2021

Our setup :

1. Issues have a Due date field

2. Issues are tagged with a Fix version

3. Releases are categorized by Fix Version , and they have a Release date

 

I want to get a list of issues where Due date is greater than Release date (i.e find issues that will probably not make it to the release) 

2 comments

Carlos Garcia Navarro
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 22, 2021

Hi @Januka Wijesinghe ,

If you have ScriptRunner, there is a datecompare function:

https://scriptrunner.adaptavist.com/4.3.1/jira/jql-functions.html#_datecompare

Januka Wijesinghe June 22, 2021

I don't see a command where the comparison is between the Due date and Release date. 

Notice that while Due date value is in the ticket itself, Release date is available on another layer. 

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
June 23, 2021

Hi Januka,

You can use Automation For Jira to do that with the Advanced Compare condition. 

Comment

Log in or Sign up to comment
TAGS
AUG Leaders

Atlassian Community Events