Query syntax help: How to determine a critical issue by comparing 2 timestamps?

Question

Hey,

I am new to the query syntax.

There are 2 timestamps:

a) Delivery deadline & b) Print completion time (Captured from post function)

I want to create a filter that shows all jobs where difference between these 2 timestamps is less than 2 hours.

Kindly share what query I should use.

Thanks!

Tarun Sapra · Answer

Date compare is supported by means of plugins like Script Runner's JQL functions in JIRA

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

Tarun Sapra · Answer

Hello Vernon,

Comparing dates isn't supported yet by the JQL in JIRA.

Please see the following links

https://jira.atlassian.com/browse/JRASERVER-20727

https://community.atlassian.com/t5/Questions/Is-it-possible-to-compare-date-fields-using-JQL/qaq-p/37331

https://community.atlassian.com/t5/JIRA-questions/JQL-Compare-Dates-Created-vs-Updated/qaq-p/339675