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. 

[Sergei Troshin · Accepted solution]

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.

[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. 

[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.

[Stephen_Lugton]

Hi @jeroen_wilmes 

By default, the startOfWeek function considers Sunday to be the first day of the week 

You can get more information here: QL Functions | startOfWeek 

[Jack Brickey · Accepted solution]

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

[Jack Brickey]

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

[Vishal Biyani]

Thanks. I was using it the wrong way.

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

[Jack Brickey]

It could be that your version is different.

[jeroen_wilmes]

Hi,  the include must have a begin and end. See the explanation from @Sergei Troshin  which is excellent.

[Vishal Biyani · Accepted solution]

@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

[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/