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

Information about how to use predicates in JQL operators

jeroen.wilmes

Hi I want to know if I can use 'During' in a JQL with a relative date like 'last week'.

and if I use dates, are the dated I mention inlcuded in the search. Meaning if I write:

During (2025-02-01, 2025-02-28) are Feb 1st and Feb 18th included in the result?

Where can I find that information.

Accepted answers

Jack Brickey

Hi @jeroen_wilmes , You must use dates for During and yes the results include the end points.

Vishal Biyani_2pr07j

@jeroen_wilmes

I don't think JQL natively supports During unless you are using some plugins.

Refer this link for list of functions that JQL supports

JQL functions | Jira Cloud | Atlassian Support

Sergei Troshin_usua2u

Hi @jeroen_wilmes, hope you're doing well!

1) Yes, you can use predicates in JQL! Here are some examples:

status WAS "Resolved" BY 62fe85c0d75f523a60eec77e DURING (startOfWeek(-1), startOfWeek(1))

status WAS "Resolved" BY 62fe85c0d75f523a60eec77e DURING ("-5d", now())

2) Yes, the boundaries of the time range are included. For example:

status WAS "Resolved" DURING ("2025/03/19", "2025/03/20")

This JQL will filter out issues that were resolved on March 19 or March 20.

All comments

Jack Brickey

Hi @jeroen_wilmes , You must use dates for During and yes the results include the end points.

Vishal Biyani_2pr07j

@jeroen_wilmes

I don't think JQL natively supports During unless you are using some plugins.

Refer this link for list of functions that JQL supports

JQL functions | Jira Cloud | Atlassian Support

Jack Brickey

I just did a quick test to see if the error message was clear which it is

Vishal Biyani_2pr07j

Thanks. I was using it the wrong way.

Also, the JQL Functions page doesn't seem to be having this function.

Sergei Troshin_usua2u

Hi @jeroen_wilmes, hope you're doing well!

1) Yes, you can use predicates in JQL! Here are some examples:

status WAS "Resolved" BY 62fe85c0d75f523a60eec77e DURING (startOfWeek(-1), startOfWeek(1))

status WAS "Resolved" BY 62fe85c0d75f523a60eec77e DURING ("-5d", now())

2) Yes, the boundaries of the time range are included. For example:

status WAS "Resolved" DURING ("2025/03/19", "2025/03/20")

This JQL will filter out issues that were resolved on March 19 or March 20.

Jack Brickey

It could be that your version is different.

jeroen.wilmes

Thanks a lot.

This worked perfect. Now I have a clear dashboard that always give the output of the columns of the kanbanboard over the previous week.

Stephen.Lugton

@Vishal Biyani

You can use During in JQL, please see @Sergei Troshin's answer

Also see WAS, WAS IN, WAS NOT IN and CHANGED in

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/

jeroen.wilmes

One last question. Do you know how a week is defined in this JQL operator?

Monday-Sunday or Sunday-Saturday

jeroen.wilmes

I found the answer:

By default the startOfWeek and endOfWeek will use Sunday and Saturday respectively. You can add a qualifier to shift that date from the default. In your example you provided, the -1w qualifier will move the default startOfWeek date back by one full week. That is why you are getting issues from 2 weeks back.

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