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

Set a field value based on created date/time/day plus X days depending of some condition

אריג' חמדאן

Hello all,

I am looking to create a custom field that will be based on create date plus days. This field will be mostly used for counting time to close based on work hours days. if an issue is created between 8:00 to 18:00 the sla should show created date plus 6 days but if it',s created between 18:00 to 8:00 it should calculate created date plus 7 date.

Example would be:

Create date=1.1.19 8:00 + 6d = 7.1.19 18:00 [it should set always a specific hour 18:00 no matter when it was created.

Created date = 1.1.19 19:00 +7d = 8.1.19 18:00

it should set the value of this addition in days and a specific hour 18:00

Any suggestions would be greatly appreciated PLEASE.

Thanks

Accepted answers

All comments

Vasiliy Zverev

Dear arie, hi!

It seems that you need a custom postfuction on create trnasition to fill this date.

There are several plugins for this.

We use Script Runner.

Best regards, Vasiliy.

אריג' חמדאן

Thank a lot

I use also scriptrunne but i m not familiar with it.

can you please help me and send me a script that i can run to get what i need as described upon?

thanks again

Vasiliy Zverev

Here is a draft,

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.event.type.EventDispatchOption
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.UpdateIssueRequest

import java.sql.Timestamp

MutableIssue issue = ComponentAccessor.getIssueManager().getIssueObject("issueKey"); //commnet into postfunction. For Script console only

Calendar newDate = Calendar.getInstance();
newDate.setTime(issue.getCreated());
int addDays = 6;
if ( (newDate.get(Calendar.HOUR_OF_DAY) < 8) & (newDate.get(Calendar.HOUR_OF_DAY) > 18) )
    addDays = 7;

newDate.add(Calendar.DAY_OF_YEAR, addDays);

issue.setCustomFieldValue( ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("fieldName"), new Timestamp(newDate.getTimeInMillis()))

//Save chanes into DB. Only for script console
ComponentAccessor.getIssueManager().updateIssue(
        ComponentAccessor.getJiraAuthenticationContext().getUser(),
        issue,
        UpdateIssueRequest.builder().sendMail(false).eventDispatchOption(EventDispatchOption.ISSUE_UPDATED).build()
)