Jira Query - Time Fields

John Wood_uy8xzn

Hi all,

 

I feel like this should be simple, but I cant figure out how!

 

I have two date/time fields, Requested window start and Requested window end (RWS and RWE from here on)

 

All I want to do is query "where RWE is greater than (RWS+2h)"

 

In other words, where the requested window is more than two hours

 

Any ideas?

Derek Fields _RightStar_

You can't do this in Jira without a plugin. Scriptrunner has a JQL function called dateCompare that will allow you to compare two dates with a range between them.

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

 

This will allow you to write JQL: issueFunction in dateCompare("", "RWE> RWS +2h")