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; } } }

Using business days instead of calendar days in JQL query for automation

Igor Kolpakov

Hi everyone!

I am having trouble setting up a simple automation. I want an automation to trigger every weekday at 10:00 AM that will leave a comment in the request (and cancel it) if there is no activity from the client (after 3 business days and after 7 business days of being moved to "Waiting for requester" status)

I did the following:

Scheduled

Mon-Fri 10:00

Run a JQL search: project = "IS" AND status = "Waiting for requester"

If matches

project = "IS" AND status = "Waiting for requester" AND NOT status changed after startOfDay(-3)

Then add comment

2. If matches

project = "IS" AND status = "Waiting for requester" AND NOT status changed after startOfDay(-7)

Then add comment and transition issue to cancelled

The problem is that it counts along with weekends, and I want ONLY weekdays (Monday - Friday 10:00 - 19:00). What should I change "NOT status changed after startOfDay(-3)/startOfDay(-7)" to so that my idea starts working correctly?

Accepted answers

All comments

Rudy Holtkamp

Hi @Igor Kolpakov ,

I think you should use '.toBusinessDay()' or a derivative from this clause.

Take a look at this page it will give you the details how to find the next business day.

Igor Kolpakov

I will try now.minusBusinessDays(3) and now.minusBusinessDays(7).

I'll reply later if it doesn't help. Thank you in advance!

Igor Kolpakov

Hmm, I got an error in the logs: No subsequent actions were performed since JQL condition did not pass due to error running JQL.

Also, in the "if" block, I entered a JQL condition: project = "IS" AND status = "Waiting for requester" AND NOT status changed after {{now.minusBusinessDays(3)}} and got a warning: If smart-values are used JQL can not be validated.

@Rudy Holtkamp am I entering something wrong or is it not possible to use smart-values in automations?

Rudy Holtkamp

@Igor Kolpakov , you did nothing wrong. It is just that if you add a JQL (without smart values) it can directly show which issues are included in you JQL (In the edit mode of the automation rule). It can't do that if you use a smart value, however you can run the rule and verify if it works.

HINT: I use a 'scheduled' trigger to test if my automation works on a sub-set of issues (preferably 1). You can do this like the picture below

1. Set the run rule every to an insane value, so it does not accidently trigger

2. Use run a JQL and include one or multiple test issues with key = KEY-1
or with key in (KEY-1, KEY-2)

3. Remove the 'Only include issues that have changed' check.

Good luck

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud