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

Can we reach to the non-working days from the Jira board via automation?

Anita Domańska

Hello Community,

I would like to exclude non-working days when calculating business days between 2 custom dates and then take -x days (probably using function .minusDays(x)).

{{issue.customfield_13359.diff(issue.customfield_13332).businessDays}}

Is it possible to reach the non-working days defined in one Jira board?

I would like to use it via Jira automation.

Thank you,

Anita

Accepted answers

All comments

Bill Sheboy

Hi @Anita Domańska

That is not possible yet with built-in features.

There is no REST API method to get at those non-working day settings in the board configuration: https://community.developer.atlassian.com/t/rest-api-getting-non-working-days/9851

I tried this same use case a few weeks ago, experimenting with a hard-coded holiday date list in a created variable, and used smart value list filtering/math functions and was not successful. If you store the list in a project entity property, with attribute names, I suspect it would be possible...although that would duplicate your non-working days in two locations.

The other work-around is a series of if/else blocks and repeated edit/re-fetch actions. With a lot of non-working days this might not fit within the 60 component limit for automation rules.

Kind regards,
Bill

Anita Domańska

Hello @Bill Sheboy -
Thank you for your reply! Did any of your workarounds worked? Is it possible you could share here the code you used for these if/else blocks?

Thank you,

Anita

Bill Sheboy

Sorry, as I ended up abandoning this use case for now after the created variable technique didn't work. Here is the question I posted to learn if someone else had solved this with lists.

To do this with condition tests, you would do something like this:

if/else condition
- add a condition to check if the start is less than or equal to the Holiday using diff() and lte()
- add a condition to check if the end date is greater than or equal to the Holiday using diff() and gte()
- action: whatever you need to exclude the holiday...probably an edit or a created variable
- action: if you did an edit, you then need a re-fetch
...repeat for each holiday

This would take 2-4 rule components for each Holiday. So this would be a difficult rule to maintain.

Charlie Gavey

Hi there,

I’ve linked your suggestion to a related feature request, which counts as an upvote for this ticket:

https://codebarrel.atlassian.net/browse/AUT-100

Thanks for letting us know.

Cheers,

Charlie

Bill Sheboy

Thanks, @Charlie Gavey !!

Anita Domańska

@Charlie Gavey- thanks One more to link with it:

https://community.atlassian.com/t5/Jira-Software-questions/How-to-calculate-business-days-including-Bank-Holidays/qaq-p/1920863?utm_source=atlcomm&utm_medium=email&utm_campaign=immediate_general_reply&utm_content=topic

John Funk

Hi @Anita Domańska - Did the responses answer your question?

Thies Uhlenbruch

@Bill Sheboy

Im just starting ... :-)

Do you have a simple automation example for one holiday? For my use case i only need 4-6 holidays so that would be no problem. I have to manipulate hundreds of issues so I don't want the manual work for the calculation.

Thank You

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

automation

diff

non-working-days