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.
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"))
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG