Scripted Field to exclude weekends

[Mani Reddy]

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. 

[PD Sheehan]

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