nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Assigning tickets depending of the hour of the day

Manuel Maldonado_m3apnk

Hi, in my Service Project I have two teams, one of them manages the issues created during the day time (until 17h CEST) and the other one manages the issues created during the nigh time (from 17h CEST).

I'm trying to automate the assignment process but I'm not being able to find a condition matching my criteria, I tried something like a JQL query as this one:

{{(now.plusHours(7).jiraDate).compareTo(now.plusDays(1).jiraDate)}} = 0

It doesn't work at all, but I'm trying to add 7 hours to now in order to compare it with tomorrow, if now+7 = tomorrow, it means that now is after 17h. I don't know if it is the best way to do it (I guess it is not), but I've not been able to find any doc to help me.

Best regards.

Accepted answers

Hana Kučerová

Hi @Manuel Maldonado

welcome to the Atlassian Community!

I believe you can use JQL condition for this, something like:

created >= startOfDay(9h) AND created <= startOfDay(17h)

If issue is created between 9 AM and 5 PM, then ...

Bill Sheboy

Hi @Manuel Maldonado -- Welcome to the Atlassian Community!

You can also do this with an advanced compare and regular expression check. Please see this post for details:

https://community.atlassian.com/t5/Automation-questions/Assigning-round-robin-according-to-the-hour-of-the-day/qaq-p/1651142

Best regards,

Bill

All comments

Hana Kučerová

Hi @Manuel Maldonado

welcome to the Atlassian Community!

I believe you can use JQL condition for this, something like:

created >= startOfDay(9h) AND created <= startOfDay(17h)

If issue is created between 9 AM and 5 PM, then ...

Bill Sheboy

Hi @Manuel Maldonado -- Welcome to the Atlassian Community!

You can also do this with an advanced compare and regular expression check. Please see this post for details:

https://community.atlassian.com/t5/Automation-questions/Assigning-round-robin-according-to-the-hour-of-the-day/qaq-p/1651142

Best regards,

Bill

Manuel Maldonado_m3apnk

Hi @Hana Kučerová thanks so much for your solution, I I didn't get it to work but I think it was because of the timezone, as my test were done assuming that the dates would be at CEST and they are actually at GTM.

However, I finally took @Bill Sheboy solution and (after noticing it was failing because of the timezone) it worked!

Thanks so much anyway!

Manuel Maldonado_m3apnk

Hi @Bill Sheboy, your solution worked great, you just need to take into account that "Created" value in a JQL is always at GTM timezone. This is how it turned out:

Captura de pantalla 2021-04-16 a las 11.08.39.png

Thanks so much!

Bill Sheboy

I am glad to hear that worked!

The way we solve the time zone issue is to adjust it before the condition test, rather than hard-code the altered time values. That prevents issues with time changes for DST and data entry errors.

For example:

{{issue.created.convertToTimeZone(issue.reporter.timeZone).format("hh")}}

BrentBot

@Manuel Maldonado can you send me screenshots of your solution. I did the same but seems only my AM shift is working. @Bill any help would be appreciated.

Use case: the am clock will assign to custom field 1 on an issue type. the pm clock will assign to custom field 2 on an issue type

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management