nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Issues updated last week

Rachel Frechette_l4mvgz

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.

Accepted answers

Harrison Ponce

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?

All comments

Harrison Ponce

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_l4mvgz

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_l4mvgz

Hi @Harrison Ponce

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

Thanks so much for your help.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud