JQL query for getting issue created on Friday between 0900 and 1600 or on the weekend since the last month ?

surajitkar July 11, 2016

Need a JQL query for retiring issue created on Fridays between 0900 and 1600 or on the weekends since the last month ?

1 answer

0 votes
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 11, 2016

Just concatenate the date ranges like this:

(created >= "2016-07-01 09:00" AND created <= "2016-07-01 16:00") OR (created >= "2016-07-02 00:00" AND created <= "2016-07-03 23:59") OR... (continue with the same structure for the remaining Fridays and weekends)

Suggest an answer

Log in or Sign up to answer