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

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

Avatar

1 badge earned

Collect

Participate in fun challenges

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

Challenges
Coins

Gift kudos to your peers

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

Recognition
Ribbon

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!

Leaderboard

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,410,328
Community Members
 
Community Events
169
Community Groups

JQL: How to extend my past day query over the weekend?

I have a query that is looking at the past day, on monday that query should include everything from Friday, through Monday.

On Tuesday-Friday that query should include only the past day through the current day.

4 answers

1 accepted

2 votes
Answer accepted

This can't be done, I've created a JIRA request, if anyone's interested go vote on it.

https://jira.atlassian.com/browse/JRA-27539

So I have this query which seems to work for this case.

status CHANGED AFTER -1d OR ( status CHANGED DURING (-3d, endOfWeek(-1w) ) ))

The during clause will be false most of the time since -3d will be after the -1w except for monday

-3d could be changed to startOfDay(-3d)

Doesn't handle holidays but Gets you 90% I think

great, thhank you for you solution! Just the last bracket in your query has to be removed in order to avoid a syntax error:

status CHANGED AFTER -1d OR ( status CHANGED DURING (-3d, endOfWeek(-1w) ) )



If you do not only want to check for status changes but for every kind of change, the following query should do the job:

updatedDate >= -1d OR ( updatedDate <= endOfWeek(-1w) AND updatedDate >= -3d)

 



 

Like # people like this

I don't have a solution to your specific question. But I'm thinking this is why we use the greenhopper RapidBoard almost as much as dashboards. We put quickfilter button's at the top to like "Updated today", "Updated -1d", "Updated -2d", "Resolved -1d", etc. By using IN in the quickfilter - e.g. dateUpdated IN (value) -you can have more than one quickfilter active on the rapidboard at once.

Only useful if you also have greenhopper though :(

We have GreenHopper, Agile is our main usecase for JIRA, but the rapid board for scrum apears wholy unfinished.

1 vote
Mizan Rising Star Feb 28, 2012

If i am right you want to filter issues , only on monday you should see issues from friday to sunday and for other weekdays it should show only of past day ... you can use 2 filters startOfDay("-3d") for monday and startOfDay("-1d") for remaining days.

I need to save the search and assign it to the filtered results dashboard gadget. I can only select one filter for that gadget. So, by my understanding I need one query that can return startOfDay(-3) on monday and startOfDay(-1) on all other days. I can't see how to perform a test that today is monday. If I could do (now()=="Monday" & startOfDay(-3)) OR (now()!="Monday" & startOfDay(-1)) I'd be set, but that doesn't work, and I can't find any documentation to help me see how to pull this off.

Suggest an answer

Log in or Sign up to answer