I'm trying to write a report to show issues that were reported after 5pm on the issue creation date. For testing, I am trying 10am to ensure a data set.
I have a series that is based on Created, and the JQL filter looks like this:
created >= startOfDay("+10h")
The report only shows issues that were created TODAY after 10am.
JQL is so strange and poorly documented that I can't figure out the correct syntax for this. There is no way that I can find to extract the time component and compare it, and various solutions online use this startOfDay() method, but it appears to use TODAY as the startOfDay() instead of the start of day of the issue's creation date.
(Anyone want to fight me on JQL being strange can explain to me why "labels = Task" translates to "labels contains Task" and yet JQL has a contains operator that is not compatible with the labels field.)
- Is there a function to retrieve the hour of a date field?
- Is there a function to retrieve the weekday of a date field?
- Is there a way to construct this report to show the information I need? (number of issues opened after 5pm on ANY DAY not just today)
Thanks.
P.S.: I can do this through brute force and a python script, but I'd rather not. For instance, this query works for the month of July:
| created < "2024-07-01 07:00" OR (created > "2024-07-01 21:30" AND created < "2024-07-02 07:00") OR (created > "2024-07-02 21:30" AND created < "2024-07-03 07:00") OR (created > "2024-07-03 21:30" AND created < "2024-07-04 07:00") OR (created > "2024-07-04 21:30" AND created < "2024-07-05 07:00") OR (created > "2024-07-05 21:30" AND created < "2024-07-07 07:00") OR (created > "2024-07-06 21:30" AND created < "2024-07-08 07:00") OR (created > "2024-07-07 21:30" AND created < "2024-07-08 07:00") OR (created > "2024-07-08 21:30" AND created < "2024-07-09 07:00") OR (created > "2024-07-09 21:30" AND created < "2024-07-10 07:00") OR (created > "2024-07-10 21:30" AND created < "2024-07-11 07:00") OR (created > "2024-07-11 21:30" AND created < "2024-07-12 07:00") OR (created > "2024-07-12 21:30" AND created < "2024-07-14 07:00") OR (created > "2024-07-13 21:30" AND created < "2024-07-15 07:00") OR (created > "2024-07-14 21:30" AND created < "2024-07-15 07:00") OR (created > "2024-07-15 21:30" AND created < "2024-07-16 07:00") OR (created > "2024-07-16 21:30" AND created < "2024-07-17 07:00") OR (created > "2024-07-17 21:30" AND created < "2024-07-18 07:00") OR (created > "2024-07-18 21:30" AND created < "2024-07-19 07:00") OR (created > "2024-07-19 21:30" AND created < "2024-07-21 07:00") OR (created > "2024-07-20 21:30" AND created < "2024-07-22 07:00") OR (created > "2024-07-21 21:30" AND created < "2024-07-22 07:00") OR (created > "2024-07-22 21:30" AND created < "2024-07-23 07:00") OR (created > "2024-07-23 21:30" AND created < "2024-07-24 07:00") OR (created > "2024-07-24 21:30" AND created < "2024-07-25 07:00") OR (created > "2024-07-25 21:30" AND created < "2024-07-26 07:00") OR (created > "2024-07-26 21:30" AND created < "2024-07-28 07:00") OR (created > "2024-07-27 21:30" AND created < "2024-07-29 07:00") OR (created > "2024-07-28 21:30" AND created < "2024-07-29 07:00") OR (created > "2024-07-29 21:30" AND created < "2024-07-30 07:00") OR (created > "2024-07-30 21:30" AND created < "2024-07-31 07:00") OR (created > "2024-07-31 21:30" AND created < "2024-08-01 07:00") |
