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; } } }

JQL Query for Calendar Week Ahead

Tarfon, Carla

I need a JQL query so i can create a filter which will pull issues scheduled for the CURRENT Mon-Fri calendar week.

I've found the below query which works and pulls the LAST calendar week info of issues done for a particular team/board (NewsDNA Commercial Design):

project = "NewsDNA Commercial Design" AND resolved >= startOfWeek(-1) AND resolved < endOfWeek(-1)

But I also need one which will pull the CURRENT week's info. To clarify - the current week info can capture all resolved or active issues to be done/that are scheduled in for the week (so not just resolved or completed items).

HELP PLEASE!!

Accepted answers

Jack Brickey

Are you using "due date" for this? If so then maybe the following will work for you.

project = "NewsDNA Commercial Design" AND duedate >= startOfWeek() AND duedate < endOfWeek()

Pramodh M

Hi @Tarfon, Carla

Welcome to the Community!!

Monday to Friday right?

Here it is :-)

due >= startOfWeek("+1d") AND due <= endOfWeek("-1d")

Please note this will return all issues that are due this week

You could start exploring dates by editing JQL in a basic format

Basic JQL.png

Thanks

Walter Buggenhout

Hi @Tarfon, Carla,

The key to what you are trying to achieve is in how you identify what is scheduled to be worked on in the current week.

The JQL queries shared by both @Pramodh M and @Jack Brickey show a correct way of searching for Jira issues. If you schedule issues to be worked on with another date custom field than due date, you could just replace due date with that other field.

As an alternative, you could also look at the way you plan work in Jira. If you set up a scrum board for scheduling, you could create sprints on e.g. weekly basis and add the items that should be worked on to them. JQL allows you to filter for all the issues in the active sprint like this:

sprint in OpenSprints()

An additional advantage would be that you can see all the active issues in one single view on that scrum board, without any further JQL being required. This would require considering the way you organise planning, but that is not necessarily a bad thing!

Hope this helps!

All comments

Jack Brickey

Are you using "due date" for this? If so then maybe the following will work for you.

project = "NewsDNA Commercial Design" AND duedate >= startOfWeek() AND duedate < endOfWeek()

Pramodh M

Hi @Tarfon, Carla

Welcome to the Community!!

Monday to Friday right?

Here it is :-)

due >= startOfWeek("+1d") AND due <= endOfWeek("-1d")

Please note this will return all issues that are due this week

You could start exploring dates by editing JQL in a basic format

Basic JQL.png

Thanks

Tarfon, Carla

Thank you! What about if the due date is still later than end of week, but is actually being worked on this current week...? This is the problem i'm having now with these later dates not pulling through.

Tarfon, Carla

thank you! I'm now having trouble pulling through any jobs that may have a later due date than the current week, but are actually being worked on IN the current week.... I'm not sure if this can ever be done without knowing exactly what jobs are scheduled in for the week and putting them in manually

Walter Buggenhout

Hi @Tarfon, Carla,

The key to what you are trying to achieve is in how you identify what is scheduled to be worked on in the current week.

sprint in OpenSprints()

Hope this helps!

Bill Sheboy

Hi @Tarfon, Carla

Adding to Jack's suggestion: to also include the in-progress items which are due *after* this week, please try:

project = "NewsDNA Commercial Design" AND duedate >= startOfWeek() AND (duedate < endOfWeek() OR statusCategory = "In Progress") ORDER BY Key

Kind regards,
Bill

Tarfon, Carla

Thanks Walter!

Pramodh M

Include only this part

due >= startOfWeek("+1d") AND updated >= startOfWeek("+1d")

to find out issues that have due date and updated issues from current week starting monday

Use time range and get comfortable with JQL Functions to dynamically adjust the weekly issues

startOfWeek() - will resolve to Sunday 00:00
endOfWeek() - will resolve to Saturday 11:59

Here's the doc

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-functions/#Advancedsearchingfunctionsreference-startOfDaystartOfDay--

Thanks,
Pramodh

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-software

jira-software-cloud