Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

how to exclude german holidays in a date script field in jira


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




0 answers

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events