Any tickets our NOC receives that's a priority 3 will prompt the NOC to search for a DBA at their desk, then move on to DBA onCall.
I want to know if there's a way to list tickets which occur only between 5pm and 6am week day and include saturday/sunday completely (Friday 5pm to Monday 6am).
That would be based on the creation date.
Thanks
Hi Nicolas,
I don't think that you can achieve that with native JQL for issues created during specific time interval on a random date. You can achieve this functionality for a limited (and small) timeframe - for example the last 3-4 days using the native time functions startOfDay/endOfDay()(e.g. for issues created during 6am - 5pm in the last three days you can use the following code:
(created >= startOfDay("-2d18h") AND created <= startOfDay("-2d7h")) OR (created >= startOfDay("-1d18h") AND created <= startOfDay("-1d7h")) OR (created >= startOfDay("-18h") AND created <= startOfDay("-7h"))
Regards,
Peter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.