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

script to set the date based on custom field value

Srikanth Gogineni

Hi ,

Please find the below scenario

we have two custom fields.

Field A the value = 2

Field B ( Date field)

Now i need to set the date ( exclude Saturday and Sunday ) for the custom field B as current date + 2 ( which means if today is Monday then field B value should be Thursday's date)

Can any one help with the post script for the above scenario.

Thanks

Accepted answers

Antoine Berry

Hi @Srikanth Gogineni ,

This code should do the trick (credits to this post) :

import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.component.ComponentAccessor

int numberFieldId = 13100
int dateFieldId = 13101

def customFieldManager = ComponentAccessor.getCustomFieldManager()

def numberField = customFieldManager.getCustomFieldObject(numberFieldId)
def dateField = customFieldManager.getCustomFieldObject(dateFieldId)

def numberFieldValue = issue.getCustomFieldValue(numberField)
def dateFieldValue = issue.getCustomFieldValue(dateField)

Calendar c1 = GregorianCalendar.getInstance();
c1.setTime(dateFieldValue)

for(int i=1;i<=numberFieldValue;i++){
c1.add(Calendar.DAY_OF_MONTH, 1);
if (c1.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY)
c1.add(Calendar.DAY_OF_MONTH, 1);
if (c1.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY)
c1.add(Calendar.DAY_OF_MONTH, 1);
}

dateField.updateValue(null, issue, new ModifiedValue(dateFieldValue, c1.getTime().toTimestamp()), new DefaultIssueChangeHolder())

Of course update custom field ids.

Antoine

All comments

Antoine Berry

Hi @Srikanth Gogineni ,

This code should do the trick (credits to this post) :

import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.component.ComponentAccessor

int numberFieldId = 13100
int dateFieldId = 13101

def customFieldManager = ComponentAccessor.getCustomFieldManager()

def numberField = customFieldManager.getCustomFieldObject(numberFieldId)
def dateField = customFieldManager.getCustomFieldObject(dateFieldId)

def numberFieldValue = issue.getCustomFieldValue(numberField)
def dateFieldValue = issue.getCustomFieldValue(dateField)

Calendar c1 = GregorianCalendar.getInstance();
c1.setTime(dateFieldValue)

for(int i=1;i<=numberFieldValue;i++){
c1.add(Calendar.DAY_OF_MONTH, 1);
if (c1.get(Calendar.DAY_OF_WEEK) == Calendar.SATURDAY)
c1.add(Calendar.DAY_OF_MONTH, 1);
if (c1.get(Calendar.DAY_OF_WEEK) == Calendar.SUNDAY)
c1.add(Calendar.DAY_OF_MONTH, 1);
}

dateField.updateValue(null, issue, new ModifiedValue(dateFieldValue, c1.getTime().toTimestamp()), new DefaultIssueChangeHolder())

Of course update custom field ids.

Antoine

Alexey Matveev

Hello,

If you already have a scripting plugin, then you should add a tag with the plugin to your question, because there are multiple plugins available and you should provide info for the one you have.

Srikanth Gogineni

Hi @Antoine Berry

Thank you very much for your code and it is working fine but there is small issue with the script.

Date field is not getting calculated properly when i move to previous/other transitions and changing the "Numberfieldvalue" . it is increment from the existing set date to new date ( not from the current date ).