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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.