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

Scripted Field to exclude weekends

Hi Everyone,


I have a scripted filed which will pull no.of days spent in a particular days. However, would it be possible to exclude weekends form the total no.of days?


import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean
import com.atlassian.core.util.DateUtils

def changeHistoryManager = ComponentAccessor.getChangeHistoryManager()

def inUseName = "In Progress"

List<Long> rt = [0L]
def changeItems = changeHistoryManager.getChangeItemsForField(issue, "status")
changeItems.reverse().each {ChangeItemBean item ->
item.toString == inUseName

def timeDiff = System.currentTimeMillis() - item.created.getTime()
if (item.fromString == inUseName) {
rt << -timeDiff
if (item.toString == inUseName){
rt << timeDiff

def newRT = rt as long []
def total = newRT.sum()/ 1000 as long
//return DateUtils.getDurationString(total)
return total/86400 as long


Thanks in advance. 

1 answer

0 votes

You would have to loop through all the dates in between your two dates and examine the day value

assert New Date().getDay() == 0 //true Sunday
assert New Date().getDay() == 6 //true on Sarturday

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events