Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

Suggest an answer

Log in or Sign up to answer
0 votes
Peter-Dave Sheehan
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 02, 2019

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

AUG Leaders

Atlassian Community Events