I am using "updatedDate <= -3d" option as of now, but i need to exclude weekends(sat,sun). Any ideas/suggestions on this would be helpful.
To refine my answer for clarity and thanks to @Steph Sjostrom , @Reply Test Group for their inputs.
The original answer was pulling updates in the last 3/5 working days. I used this with a NOT criteria to pull the ones before. Which I admit I did not make clear in the original post.
So you can do
AND NOT ( updated >-3d OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek()))The following identifies issues updated before 3 working days without using NOT.
( (updated <-3d AND updated > startofWeek() ) OR updated < -5d)
Hi @Satish M
Welcome to the Atlassian community where other users try to help each other.
You need to split your problem in to two parts. The easy part as you have already is the current week within the last 3days
The second part is to look for when the 3 days straddles a weekend. In which case you want to make this 5days but you only want entries that are in last week and not in current week. so you can add the criteriaupdated >-3d OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek(1d))What this does is look for updated within the last 5 days that are updated since the start of the week beginning on a Thursday and before the start of the week beginning on a Sunday. The important part here is that the -5d will roll forward as the week progresses so on a Monday that will reference Thursday but on Tuesday it will reference Friday whilst the startOfWeek will remain locked on Thursday to Sunday. Once you get to Wednesday the -5d will be Saturday and so will exclude the previous week as you now have Mon-Wed in the current week.
Hope this helps you
Phill
Feb 2022 - amended answer to be clear on startOfWeek being defaulting to Sunday.
Thanks Phill, tried that, but it didn't work, any other alternative option?
Just put:
updated >-3d OR (updated > -5d AND updated > startofWeek(-3d) AND updated < startofweek())
, with the 'd' after the first '3' ; )
Cheers
I tried this but it didn't work, any idea?
@Phill FoxCould you help me here?
This is what I have:
project = "Delivery Management System" and (labels = DMSE or "Assigned Team" = DMSE) and status not in ("In Release", Released, Open, "Not Done", "Closed") and issuetype = Story AND Sprint in openSprints() AND NOT status changed AFTER -7d
What I need:
Tickets which are not in the mentioned statuses, with the last status update 7 days ago, excluding saturday and sunday.
Thank you,
can you suggest the answer as per the status, that the issue is in the following status for the last 3 business days?
Hi @Phill Fox , can you suggest me the same jql but using "status changed"? status changed can accept just "after" and "before". Thanks
hi i need to send mail for inactive issue for last 2 days after it got assigned how to achive this
It looks like you're new here. Sign in or register to get started.
