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

how can i populate a custom field with users local current date?

t_dmjwzx

Hi,

Globally we are using JIRA and need to record when something is marked as done it stores the local date on the users machine not the date on the server for that issue.

How can i achieve this? i know it will need to be coded but im not sure on how to achieve this, i do have script runner.

Accepted answers

All comments

Vasiliy Zverev

So, you need to perform two steps:

1) learn how to update custom field of date type

2) learn how to get local type.

Lets start with step 1:

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

import java.sql.Timestamp

CustomField customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("custom field name 1")
if(customField == null)
    return "no such custom field"

//Not requared into a postfunction
MutableIssue issue = ComponentAccessor.getIssueManager().getIssueObject("ZVER-10")
if(issue == null)
    return "an issue not found"

//Here we set requred date
Calendar dateToSet = Calendar.getInstance(); //here you could get local time on user machine. But I am not sure

issue.setCustomFieldValue(customField, new Timestamp(dateToSet.getTimeInMillis()))

//Here we do the update. Not requared into postfunction
ComponentAccessor.getIssueManager().updateIssue(ComponentAccessor.getJiraAuthenticationContext().getUser().getDirectoryUser(), issue, EventDispatchOption.ISSUE_UPDATED, false)

I think that this code should set local time, but I am not sure. Try it.

JamieA

"when something is marked as done it stores the local date on the users machine not the date on the server for that issue"

That's not the case... it stores the server date but will display the date in the timezone of whoever is looking at it. At least that's since JIRA 4.4.

If you want to get the user timezone, you will need to look up the timezone preference for the user and make the adjustment.

t_dmjwzx

Thats the problem........ for reporting purposes i dont want to change my timezone to each different destination every time i have to do reports.. we have over 8 timezones across various projects... i need to calculate from this date to this date regardless of timezone thus having a field that stores the local machine time a way to solve this problem

t_dmjwzx

where do i put all this code into exactly? sorry im only used to putting java/javascript into the description of a field

Vasiliy Zverev

This code should be inserted into Scripted postfunction provided by ScriptRunner Plugin.

For test properties you can use ScriptConsole. See this:https://answers.atlassian.com/questions/32982259

In this case you should specify an issue (see line MutableIssue issue = ComponentAccessor.getIssueManager().getIssueObject("ZVER-10"))

t_dmjwzx

Do i delete all bits of code that have //not required into post function ?

So like this:

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.event.type.EventDispatchOption
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.issue.fields.CustomField
 
import java.sql.Timestamp
 
CustomField customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("customfield_11520")
if(customField == null)
    return "no such custom field"
 
 
//Here we set requred date
Calendar dateToSet = Calendar.getInstance(); //here you could get local time on user machine. But I am not sure
 
issue.setCustomFieldValue(customField, new Timestamp(dateToSet.getTimeInMillis()))

Also do i just use a normal date picker custom field? or do i need to use a scripted field or calculated date/time field?

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

jira

jira-core

scripted-field