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
4,369,314
Community Members
 
Community Events
168
Community Groups

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

Edited

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

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events