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

looking for a date field to display the value of another custom field plus 10 days in date format

Philemon Nkafu

I have a transition timestamp field (Medical Record Requested) that captures the date of a specific transition. I would like script runner to help me enable another field to display date of the transition field + 10 days. I have created a scripted field using script runner but it is displaying an error.

Below is the script:

import com.atlassian.jira.component.ComponentAccessor

final String customField = "Medical Record Requested"

def startDate = Calendar.instance
def endDate = Calendar.instance

def changeHistoryManager = ComponentAccessor.changeHistoryManager
def transition = changeHistoryManager.getChangeItemsForField(issue, customField)

startDate.setTime(transition*.created.max())

int weekDays = 10
while (startDate.timeInMillis < endDate.timeInMillis) {
startDate.add(Calendar.DAY_OF_MONTH, 1)
startDate.get(Calendar.DAY_OF_WEEK) in [Calendar.SATURDAY, Calendar.SUNDAY] ? null : ++weekDays
}

weekDays

Below is the error am getting after I execute the targeted transition:

$dateFormatterWithoutTime.format($value)

Please I would need some help

Accepted answers

Philemon Nkafu

Hi Gustavo,

The log does not show any error.

Gustavo Félix_5ziaxu

Im almost sure is this line:

startDate.setTime(transition*.created.max())

Based on this:
https://community.atlassian.com/t5/Jira-questions/Not-able-to-get-last-custom-field-value-using/qaq-p/854451

I tried this and it returned the date:

List<ChangeItemBean> transitions = changeHistoryManager.getChangeItemsForField(issue,"your field name")
return transitions.get(transitions.size()-1).created

so, I guess this + your code could work
List<ChangeItemBean> transitions = changeHistoryManager.getChangeItemsForField(issue,"your field name")
startDate.setTime(transitions.get(transitions.size()-1).created)

int weekDays = 10
while (startDate.timeInMillis < endDate.timeInMillis) {
startDate.add(Calendar.DAY_OF_MONTH, 1)
startDate.get(Calendar.DAY_OF_WEEK) in [Calendar.SATURDAY, Calendar.SUNDAY] ? null : ++weekDays
}

Let me know if it works.

Philemon Nkafu

Hello Gustavo,

I ran to a problem with the script and I hope you may be able to help. The script is not returning a due date for "Medical Record Requested" value entered in the past. I basically want to have the field populate due dates for past tickets. Right now, it is only returning for values entered now.

Appreciate your help.

All comments

Gustavo Félix_5ziaxu

Hi @Philemon Nkafu
Does the log shows you the line were it fails ?

Philemon Nkafu

Hi Gustavo,

The log does not show any error.

Gustavo Félix_5ziaxu

Ok, two questions:
What template are you using for your scripted field?
If you go to issues->custom Fields-> edit your custom field... what search template are you using?

Philemon Nkafu

I am using the Date Time template

and the searcher is the date time range picker

Gustavo Félix_5ziaxu

Im almost sure is this line:

Philemon Nkafu

Scripted Field Error 9.24.2020.JPG I am getting the following error. I am creating a scripted field, could that be the issue? It seem you want me to do a post function instead.

Also, my requirement is not 10 days from issue creation date. It is from a Custom field (Medical Record Requested) that only gets completed at a different transition.

Gustavo Félix_5ziaxu

Sorry , I forgot to add the import.
import com.atlassian.jira.issue.history.ChangeItemBean
I was also using a scripted field.
The 10 days that I add, was just to test the code, you can modify that part with your code.

Let me know if it works

Philemon Nkafu

Evenning modification scripted field for 10 days from date type CF value.JPG

Philemon Nkafu

Hello Gustavo,

Appreciate your help.

Gustavo Félix_5ziaxu

I'm not sure if I understand .
When the scriptfield is executed you want to get past values for "Medical Record Requested. Then, you want to populate other tickets with this values?

Philemon Nkafu

Hello Gustavo,

Am getting the following error message

Time (on server): Tue Sep 29 2020 11:58:12 GMT-0500 (Central Daylight Time)

The following log information was produced by this execution. Use statements like:log.info("...") to record logging information.

2020-09-29 11:58:12,576 ERROR [customfield.GroovyCustomField]: *************************************************************************************
2020-09-29 11:58:12,576 ERROR [customfield.GroovyCustomField]: Script field failed on issue: CSL-78632, field: Medical Record Due
java.lang.ArrayIndexOutOfBoundsException: -1
 at java_util_List$get$3.call(Unknown Source)
 at Script11.run(Script11.groovy:14)

Medical Record Due failed executions.JPG

Gustavo Félix_5ziaxu

I guess the line 14 is

startDate.setTime(transitions.get(transitions.size()-1).created)

This is because when you create an issue , your transition size is 0.
That's why the -1.

So, do you need this to work when the issue is created?

Philemon Nkafu

Hi @Gustavo Félix

I have another issue with a separate script. I am calculating the age of a person based on the DOB value. The script is fine except that am getting a NULL Pointer exception error. I will need some help with adding a line that would return a NULL if the field is empty or better still ignore empty field. Below is the script I have and would appreciate your input.

import com.atlassian.jira.component.ComponentAccessor
import java.time.Period
import java.time.LocalDate
import java.time.ZoneId

def customFieldManager = ComponentAccessor.customFieldManager
def dob = customFieldManager.getCustomFieldObjectsByName("DOB")[0]
def dobValue = dob.getValue(issue) as Date

static def convertToLocalDateViaInstant(Date dateToConvert) {
return dateToConvert.toInstant()
.atZone(ZoneId.systemDefault())
.toLocalDate()
}

def today = LocalDate.now()
def birthday = convertToLocalDateViaInstant(dobValue) as LocalDate

def age = Period.between(birthday, today)

return String.format("%d years", age.getYears())

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