JQL queries - some questions regarding using dates

Bojana Vasic July 23, 2018

Hi guys,

I have noticed that some of the documentation around the JQL queries looks a bit odd, please correct me if I'm wrong, please see examples (taken from https://confluence.atlassian.com/jirakb/reporting-in-jira-461504615.html#ReportinginJIRA-question) below:

Example1:

Assignments that are overdue or due in the next 7 weeks.

assignee = currentUser() AND resolution = Unresolved and duedate <= startOfDay(7) order by duedate asc

Shouldn't it say: duedate >= startOfDay(7w) instead?

Example2:

Recently closed Incidents, Problems, Changes; In this query, all issues that have been resolved within the last seven days (-7) are shown.

project = Your_Project and status in (resolved, closed) and resolutiondate < startofday(-7) and issuetype = Respective_Type order by priority desc

However, this query shows all issues closed ever < startofday -7...

Shouldn't it say resolutiondate >= startOfDay(-7d) instead?

What is the default, when the number stands alown, without d/w/m/y?

Many thanks!

1 answer

0 votes
Danyal Iqbal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 23, 2018

 +1 for Bug. Actually +2 :)

Danyal Iqbal
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 23, 2018

Please inform the nice folks at atlassian.

Suggest an answer

Log in or Sign up to answer