Get product advice from experts

Ask a question →

Join a community group

Find a group →

Advance your career with learning paths

Take a free class →

Earn badges and rewards

Connect and share ideas at events

See the calendar →

Community
Products
Jira
Questions
JQL Query for all stories and tasks due this week

JQL Query for all stories and tasks due this week

In the Active Sprint view, I would like to filter all Stories and Tasks 'Due This Week'.

Below are some JQLs tried and failed:

"Due date" = startOfWeek(6d)

"Due date" = 1w

2 answers

1 accepted

2 votes

Answer accepted

Try something like:

duedate <= startOfWeek(5d) and duedate > startOfWeek()

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Appreciate the quick reply Gregory. Ultimately, combination of yours and below worked.

"Due date" = startOfWeek(5d)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

@Gregory Van Den Ham That worked perfectly for me. Thanks.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • Dave Liao likes this

Can I assume that due next week would be "Due date" = startOfWeek(10d)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like

Reply

1 vote

You can also get things in your current sprint with:

project = "your project name here" AND sprint in openSprints()

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Reply

Suggest an answer

Log in or Sign up to answer

Was this helpful?

Thanks!

TAGS

Community showcase