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!
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/JIRA-questions/JQL-Compare-Dates-Created-vs-Updated/qaq-p/339675
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.