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

Mohit August 1, 2017

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! 

1 answer

0 votes
Tarun Sapra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 2, 2017
Tarun Sapra
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 2, 2017

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

Suggest an answer

Log in or Sign up to answer