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

Use Scriptrunner Post-function to set custom time value within custom Date Time Picker field

Michael_qy22gs

Hi everyone,

We have a Date Time Picker field (Called "Team Due Date") within our Create screen, which asks the users to input a custom "team" due date.

Within a post function, we would like to adjust JUST the time of this "Team Due Date" field to be the EOD (end of business day) for the due date selected.

Is it possible to do this?

For Example: A user inputs 3/3/2024 00:00:00am -> We would like the post function to change just the time to be our EST end of day, meaning: "3/3/2024 17:00:00pm".

Thanks,

Mike

Accepted answers

Ram Kumar Aravindakshan _Adaptavist_

Hi @Michael

This is very much doable with ScriptRunner, and it's even simpler when using ScriptRunner's HAPI feature.

Below is an example working code for your reference:-

import groovy.time.TimeCategory
import java.sql.Timestamp

def currentDueDate = issue.getCustomFieldValue('Time Due Date') as Date
def endOfDay = new Date()

use( TimeCategory ) {
    endOfDay = currentDueDate + 17.hours
}

issue.set {
    setCustomFieldValue('Time Due Date', new Timestamp(endOfDay.time))
}

Please note that the sample working code above is not 100% exact to your environment. Hence, you will need to make the required modifications.

Below is a screenshot of the Post-Function configuration:-

If you observe the screenshot above, the ScriptRunner editor is complaining about a TypeScript check. You can ignore it, as the code works just fine.

Below are a couple of test screenshots for your reference:-

1. When the issue is first created, the date is set to 15 February 2024 00:00:00, but the format displayed in this instance is 15/Feb/24 12:00 AM.

2. Once the issue transitions to In Progress, as expected, the date time field is updated to 15 February 2024 17:00. The format displayed is 15/Feb/24 5:00 PM.

I hope this helps to solve your question. :-)

Thank you and Kind regards,
Ram

All comments

Tinker Fadoua

@Michael

My guessing is yes

You get your custom field value

then apply a method that will increase the time to desired timing https://www.tutorialspoint.com/groovy/groovy_dates_times.htm

I can try it if you are willing to wait until tomorrow.

Best,

Fadoua

Ram Kumar Aravindakshan _Adaptavist_

Hi @Michael

This is very much doable with ScriptRunner, and it's even simpler when using ScriptRunner's HAPI feature.

Below is an example working code for your reference:-

import groovy.time.TimeCategory
import java.sql.Timestamp

def currentDueDate = issue.getCustomFieldValue('Time Due Date') as Date
def endOfDay = new Date()

use( TimeCategory ) {
    endOfDay = currentDueDate + 17.hours
}

issue.set {
    setCustomFieldValue('Time Due Date', new Timestamp(endOfDay.time))
}

Please note that the sample working code above is not 100% exact to your environment. Hence, you will need to make the required modifications.

Below is a screenshot of the Post-Function configuration:-

If you observe the screenshot above, the ScriptRunner editor is complaining about a TypeScript check. You can ignore it, as the code works just fine.

Below are a couple of test screenshots for your reference:-

1. When the issue is first created, the date is set to 15 February 2024 00:00:00, but the format displayed in this instance is 15/Feb/24 12:00 AM.

2. Once the issue transitions to In Progress, as expected, the date time field is updated to 15 February 2024 17:00. The format displayed is 15/Feb/24 5:00 PM.

I hope this helps to solve your question. :-)

Thank you and Kind regards,
Ram

Michael_qy22gs

Hello again @Ram Kumar Aravindakshan _Adaptavist_

I've just tried your code above during the "create" transition, and we were able to get it to work; but it only adds 17 hours to the currently input time.

By default, Jira selects the current "time", so none of these scripted tickets will have their time set to 5pm (17:00) unless someone enters a ticket 17hrs before 5pm.

Is it possible to update this code so that the time is set to exactly 5pm regardless of what the user enters?

Thanks,

Mike

Michael_qy22gs

Hello @Tinker Fadoua

We are looking to "overwrite" the time that the user inputs to a specific time instead of just adding time.

The times at which a user will input a request will be dynamic, so we'd need a dynamic solution, or just the ability to "overwrite" the time entered to be "17:00est" (5pm est) which is the end of business day. (EOBD)

Do you have any ideas for this?

Thanks,

Mike

Ram Kumar Aravindakshan _Adaptavist_

Hi @Michael

It is possible, but I need to play around with the code.

I'll get back to you once I have the update.

Thank you and Kind regards,

Ram

Ram Kumar Aravindakshan _Adaptavist_

Hi @Michael

Below is the updated working code that I have tested with:

import java.sql.Timestamp
import java.text.SimpleDateFormat

def currentDueDate = issue.getCustomFieldValue('Time Due Date') as String

def format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS")
def calendar = new GregorianCalendar()
def dateToFormat = format.parse(currentDueDate)
calendar.setTime(dateToFormat)

def currentTime = dateToFormat.toLocalTime()
def hoursDifference = 0
def minutesDifference = 0
def secondsDifference = 0

if (currentTime.hour < 17) {
    hoursDifference = 17 - currentTime.hour
    minutesDifference = currentTime.minute * -1
    secondsDifference = currentTime.second * -1
} else if (currentTime.hour == 17) {
    hoursDifference = 0
    minutesDifference = currentTime.minute * -1
    secondsDifference = currentTime.second * -1
} else if (currentTime.hour > 17) {
    hoursDifference =  (currentTime.hour - 17) * -1
    minutesDifference = currentTime.minute * -1
    secondsDifference = currentTime.second * -1
}

calendar.add(Calendar.HOUR, hoursDifference)
calendar.add(Calendar.MINUTE, minutesDifference)
calendar.add(Calendar.SECOND, secondsDifference)

issue.set {
    setCustomFieldValue('Time Due Date', new Timestamp(calendar.time.time))
}

With the updated code, irrespective of the time that has been entered into the field, it will automatically reset to 17:00, i.e. 5:00pm

If you observe the screenshots below, irrespective of the time I set in the Time Due Date field, i.e. Date Time field, once the issue is created, it is automatically set to 5:00 p.m.

I hope this helps to solve your question. :-)

Thank you and Kind regards,

Ram

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

post-function

groovy

script