SIL Script to count Workday

[Carla Dumale]

Hi, I want to create custom field to count the age/workday based on the creation date field, excluding the Holidays and Week ends. Can anyone help? I am using Jira-cloud. Thanks!

[Alexey Matveev · Accepted solution]

Hello,

The Cloud architecture does not support scripted custom fields, that is why you can not do it on Cloud.

[Carla Dumale]

Thanks for the answer. But as of now, we are using plug-ins to add SIL in some of the custom field. Now I want to add custom field wherein I can count the days since the issue has been created, excluding holidays and weekends.

[Alexey Matveev]

I am not sure how you add a sil script to a custom field in Cloud. But if you can do it, then you should use this function:

number days;
date startDate = "2012-01-10 12:00:00";
date endDate = "2012-01-20 10:30:00";
string startHour = "09:00";
string endHour = "17:00";
number[] weekend = {7, 1};
date[] holidays = {"2012-01-18", "2012-01-16"}; 
number hours = getWorkingInterval(startDate, endDate, startHour, endHour, weekend, holidays);
days = hours/8;
return days;

[Carla Dumale]

Thank you! :) This helped. I got another query, how can I make it possible to start the counting the number of workday on next day? E.g. When issue was created today, the start of counting of workday will be tomorrow. 

[Alexey Matveev]

I think it should be like this:

number days;
date startDate = created;
startDate = startDate + "1d";
date endDate = "2012-01-20 10:30:00";
string startHour = "09:00";
string endHour = "17:00";
number[] weekend = {7, 1};
date[] holidays = {"2012-01-18", "2012-01-16"}; 
number hours = getWorkingInterval(startDate, endDate, startHour, endHour, weekend, holidays);
days = hours/8;
return days;

[Carla Dumale]

Yes, this is also the solution I came up with. Last question ^^, how to make the counter stop once the status has been resolved, and continue while it remains unresolved? Thank you for the help!

[Alexey Matveev]

You would need to combine the script above with this one:

https://confluence.cprime.io/display/TR/Get+time+spent+in+certain+status+per+issue

[Carla Dumale]

Thank you so much~ :) 

[Alexey Matveev]

You are welcome!