Issues updated last week

[Rachel Frechette]

I can get a list of issues that were updated this week: 

("Team Name" = SPEED-Benefits-BHub-1) AND updated >= startOfWeek() AND updated <= endOfWeek() AND type not in (Objective,Feature) AND status not in (Backlog, "Won't Do")

But I'm not having any luck getting the issues that were updated last week.

Can anyone please help me? I've tried many things, and nothing is working for me.

Thank you in advance.

[Harrison Ponce · Accepted solution]

Hi @Rachel Frechette , great question!

Working with dates in JQL can be kind of tricky! You might want to use something like the following in your JQL:

updated >= startOfWeek("-1") AND updated < startOfWeek()

This will show you for calendar week, Sun-Sat.

Does this help?

[Rachel Frechette]

So, I used what you gave me and it's still not giving me the correct issues. I should have at least a dozen issues returned from last week, but I only get two. This is the query I'm using now.

"Team Name" = SPEED-Benefits-BHub-1 AND updated >= startOfWeek("-1") AND updated < startOfWeek() AND type not in (Objective, Feature) AND status not in (Backlog, "Won't Do", Blocked)

[Harrison Ponce]

I wonder if some of the issues that are missing are being filtered out because of something like their current status? This one's a little harder to help with online without seeing the issues :/

I would be happy to take a look with you on a call some time if you would like to connect! Whatever we figure out, I'm happy to post here to summarize.

[Rachel Frechette]

Hi @Harrison Ponce 

I had mistyped the jql you gave me. it is working now.

Thanks so much for your help.

[Harrison Ponce]

Woohoo!! We love when the JQL works! You're so welcome :-)