JQL for After Hours and Weekends

Rainy Hausen

How do I write JQL to reflect tickets that were created on weekends and after 5pm on weekdays for certain Issue types? 

Riley Venable

To write JQL to reflect tickets that were created on weekends and after 5pm on weekdays for certain Issue types, you can use the following query: ``` createdDate >= startOfWeek(-1d) and ( (createdDate >= startOfDay() + 17h or createdDate < startOfDay() + 8h) and issueType in (issueType1, issueType2, issueType3) ) ``` This query searches for issues that were created after 5pm on weekdays and on weekends for the specified issue types.

The `createdDate` field is compared to the start of the current week minus one day (`startOfWeek(-1d)`) to include the entire previous weekend. It then checks if the issue was created after 5pm (`createdDate >= startOfDay() + 17h`) or before 8am (`createdDate < startOfDay() + 8h`) on weekdays.

Finally, it filters by the specified issue types using the `issueType in (issueType1, issueType2, issueType3)` clause.

Note that `startOfDay()` and `startOfWeek()` are functions that return the start of the current day or week, respectively, and `17h` and `8h` specify the start times for the weekdays. You can adjust these values as needed to fit your specific requirements.