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

Time custom field question

Rumceisz

Hi All,

I created a scripted field which results the time in a particular status for each issue.

The endusers will export the report to excel which contains this custom field value. The problem is that this field - according to the time spent in that status - contains '2d 1h' or '3w 4d 4m' values and they need every value only in minutes because of the excel.

How can we do that?

Thanks in advance!

Rumi

Accepted answers

Florin Manaila4

You need to specify a separate template for the excel view in your atlassian-plugin.xml and use it to format the time in minutes only.

&lt;resource type="velocity" name="excel" location="mytemplate.vm"/&gt;

All comments

Maxim Abramovich

Where you render field representaion? In script or in velocity template? If in template, you need separate template for excel export

Florin Manaila4

You need to specify a separate template for the excel view in your atlassian-plugin.xml and use it to format the time in minutes only.

&lt;resource type="velocity" name="excel" location="mytemplate.vm"/&gt;

Rumceisz

Hi,

the excel export will be generated from Issue Navigator. Can I implement this script to a scripted field?

Rumceisz

Hi,

the excwel export will be generated from the Issue Navigator.

Florin Manaila4

The excel view will be used whenever you custom field will be used in an "export to excel" action regardless of what/where it was triggered from.

I'm not sure I understand what you mean by scripted field. I thought you meant you wrote the plugin for the custom field yourself, in which case the above solution is correct. However, if you use a third party plugin you need to clarify this with the developer.

Rumceisz

ok,

sorry:)

the current custom field which results the time spent in the particular status is a scripted field I made.

The field will be displayed in the issue navigator and the results (about 300 issues) will be exported to excel.
The users who need these custom field ask for displaying these time values in 'Minutes' in order to easily compare in the excel report.
So I think there is nothing to do with excel: can the script be altered to display the time spent in minutes?

here is the code:

import com.atlassian.core.util.DateUtils
import com.atlassian.jira.ComponentManager
import com.atlassian.jira.issue.history.ChangeItemBean
 
def componentManager = ComponentManager.getInstance()
def changeHistoryManager = componentManager.getChangeHistoryManager()
 
def inProgressName = "Clarification"
 
def rt = [0]
changeHistoryManager.getChangeItemsForField (issue, "status").reverse().each {ChangeItemBean item ->
 
    def timeDiff = System.currentTimeMillis() - item.created.getTime()
    if (item.fromString == inProgressName) {
        rt << -timeDiff
    }
    if (item.toString == inProgressName){
        rt << timeDiff
    }
}
 
// NOTE: doesn't show anything if less than 60 seconds
DateUtils.getDurationString(Math.round(rt.sum() / 1000))

Welcome!

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

Quick Links

Find more posts tagged with

custom-field

jira

time