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

Need help to set DueDate automatically filled in as 5 days after creation of issue

Vijaya Kumara

Dear All,

I am quite new to Jira / Confluence and I am not from development background.

I need to set an Automatic date for Duedate for issues = 5 days after creation of Issue should be DueDate, Should exclude Saturdays and Sundays.

I used a expression / Code from blog as below, but got error messages. To be honest I don't know anything about programming.

Used expression

issue.setDueDate (new Timestamp (cal.getTimeInMillis() + 5 * 1000 * 24 * 60 * 60))

Error message

Unable to resolve class Timestamp @Line 1, column19

I am using Jira v7.13.3

Could you please help and guide

Accepted answers

Leonard Chew

Hi there

Do it with a Scriptrunner Postfunction.

Create a scriptrunner postfunction on your create transition, type: custom
Move the Postfunction between the creation step and the re-index step
Add this code

import org.apache.log4j.Level
log.setLevel(Level.DEBUG)

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.event.type.EventDispatchOption

def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def issueManager = ComponentAccessor.getIssueManager()
def creation = issue.getCreated()
def daysToShift = 5

def newDueDate = creation + daysToShift
def dayOfWeek = newDueDate.getDay()

switch (dayOfWeek) {
case 0 : newDueDate = newDueDate + 1 // sunday
log.debug('Adding 1 day to Sunday')
break
case 6 : newDueDate = newDueDate + 2 // saturday
log.debug('Adding 2 days to Saturday')
break
}

issue.setDueDate(newDueDate)
issueManager.updateIssue(user, issue, EventDispatchOption.DO_NOT_DISPATCH, false)

log.debug(issue.key+': Due Date has been set to ' + newDueDate)

If it works, you can remove the debug level in production by changing level.DEBUG to level.WARN

All comments

Ravi Sagar _Sparxsys_

Hi @Vijaya Kumara

Where exactly did you try the expression that you mentioned above?

You would need an app/add-on like ScriptRunner for doing this.

Ravi

Vijaya Kumara

Hi @Ravi Sagar _Sparxsys_ Yes I have Script Runner add on

Leonard Chew

Hi there

Do it with a Scriptrunner Postfunction.

Create a scriptrunner postfunction on your create transition, type: custom
Move the Postfunction between the creation step and the re-index step
Add this code

import org.apache.log4j.Level
log.setLevel(Level.DEBUG)

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.event.type.EventDispatchOption

def user = ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser()
def issueManager = ComponentAccessor.getIssueManager()
def creation = issue.getCreated()
def daysToShift = 5

def newDueDate = creation + daysToShift
def dayOfWeek = newDueDate.getDay()

switch (dayOfWeek) {
case 0 : newDueDate = newDueDate + 1 // sunday
log.debug('Adding 1 day to Sunday')
break
case 6 : newDueDate = newDueDate + 2 // saturday
log.debug('Adding 2 days to Saturday')
break
}

issue.setDueDate(newDueDate)
issueManager.updateIssue(user, issue, EventDispatchOption.DO_NOT_DISPATCH, false)

log.debug(issue.key+': Due Date has been set to ' + newDueDate)

If it works, you can remove the debug level in production by changing level.DEBUG to level.WARN

Vijaya Kumara

@Leonard Chew - Thank you for all the information, I just a beginner - Could you please send some screen shots on steps I need to follow to get this Implemented.

I tried below option but didn't know how to proceed to next step.

I created a transition in workflow as custom

I also got below error messages in console

Leonard Chew

Hmm, if you lack knowledge of jira-administration basics, it might be wise to persuade your manager to give you an administration course, before you work with scripts.

That said, here are the answer to your questions:

1) General: The script will not work if you paste it in to the script console, as the console does not know on which issue it should run on.
In a postfunction-script, the issue is automatically set to the issue currently being transitionend (created in our case).

2) Do NOT create a new transition. This postfunction should run on the initial "Create"-Transition, which is the line from the circle to the first status. The script automatically sets the due date when an issue is created through this workflow.

Here are some screenshots pasted together to get it to work:

Vijaya Kumara

@Leonard Chew - Thanks a lot for your support, I was able to complete the steps. But I don't see Due Date getting filled in Automatically.

Is there any additional steps I need to complete.

Welcome!

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

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-server