Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How to display script field in format "xx D YY h ZZ m QQ s"

Norbert Grzebieniarz September 26, 2018

Dear Community,

I have a field that calculates the difference between two dates:

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.util.*
import java.util.Date.*

def customFieldManager = ComponentAccessor.getCustomFieldManager();
def dateResponse = customFieldManager.getCustomFieldObjectByName('Date of First Response');

if(issue.getCustomFieldValue(dateResponse) && issue.created)
{
def dateValue= issue.getCustomFieldValue(dateResponse) as Date
def dateValue2= issue.created
def dif = dateValue.getTime() - dateValue2.getTime()
return dif
}

I want to display value of this field in format: "XX Days YY Hours ZZ Minutes QQ Seconds"

Anyone can help me out?

Thanks in advance.

2 answers

Suggest an answer

Log in or Sign up to answer
0 votes
Norbert Grzebieniarz September 26, 2018

Now it is fixed.

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.util.*
import java.util.Date.*
import com.atlassian.core.util.DateUtils

def customFieldManager = ComponentAccessor.getCustomFieldManager();
def dateResponse = customFieldManager.getCustomFieldObjectByName('Date of First Response');

if(issue.getCustomFieldValue(dateResponse) && issue.created)
{
def dateValue= issue.getCustomFieldValue(dateResponse) as Date
def dateValue2= issue.created
def dif = dateValue.getTime() - dateValue2.getTime() as float
return DateUtils.getDurationString(Math.round(dif / 1000))
}

Script Field:

Template: Text Field (multi-line)

Searcher: Free text searcher

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 26, 2018

You could use brute force to calculate the d/h/m/s from the raw number of seconds, but I'd use Jira's date formatter myself - https://docs.atlassian.com/software/jira/docs/api/7.12.1/com/atlassian/jira/util/JiraDurationUtils.html

Norbert Grzebieniarz September 26, 2018

@Nic Brough -Adaptavist- I will be grateful for more directions. :)

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 26, 2018

There's sample code on https://scriptrunner.adaptavist.com/4.1.3.7/jira/working-with-tempo.html  (I know, a little odd to point you at Tempo integration, but actually the code is for any duration, not just Tempo data)

Norbert Grzebieniarz September 26, 2018

Thank you. It's working, but the calculation is wrong:

1st.jpg2nd.jpg

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.util.*
import java.util.Date.*

def customFieldManager = ComponentAccessor.getCustomFieldManager();
def dateResponse = customFieldManager.getCustomFieldObjectByName('Date of First Response');

if(issue.getCustomFieldValue(dateResponse) && issue.created)
{
def dateValue= issue.getCustomFieldValue(dateResponse) as Date
def dateValue2= issue.created
def dif = dateValue.getTime() - dateValue2.getTime()
return dif as Long
}
#if($value)
$jiraDurationUtils.getFormattedDuration($value)
#end

 Any ideas why?

TAGS
AUG Leaders

Atlassian Community Events