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,364,763
Community Members
 
Community Events
168
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
TAGS

Atlassian Community Events