Hi All,
I have created a script field to calculate the status duration of an issue. But i want to exclude all the German holidays from the calculation.
Could any one please help me how to do this.
Below is the script to calculate status duration.
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean
def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()
def inProgressName = "status_name" List<Long> rt = [0L]
def changeItems = changeHistoryManager.getChangeItemsForField(issue, "status") changeItems.reverse().each { ChangeItemBean item ->
def timeDiff = System.currentTimeMillis() - item.created.getTime()
if (item.fromString == inProgressName) {
rt << -timeDiff
}
if (item.toString == inProgressName) {
rt << timeDiff
}
}
def total = rt.sum() as Long
return (total / 1000) as long ?: 0L
Regards,
Goutam