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

i want to write a JQL to know all issues for which due date <= (start of day+7)

pragati bhatia

basically I want to know through JQL all issues that are due in coming 7 days. any leads?

Accepted answers

Bogdan Gorka

Use the simple search engine and select your options

2019-05-06 10_10_43-Window.png

Then, if you select the Advanced option, you will see how it translates into JQL.

In my example it was:

project = DMP AND due <= 7d

More about comparing fields with operators can be found here: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-operators-reference-764478341.html

pragati bhatia

due >= startOfDay() AND due <= 7d

All comments

Bogdan Gorka

Use the simple search engine and select your options

2019-05-06 10_10_43-Window.png

Then, if you select the Advanced option, you will see how it translates into JQL.

In my example it was:

project = DMP AND due <= 7d

More about comparing fields with operators can be found here: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-operators-reference-764478341.html

Merve Nur Bas

Hey @pragati bhatia ,

"due <= 7d" will show every issue due in the upcoming 7 days and overdue ones. Try the following JQL for a range between today and the next 7 days.

due >= startOfDay() AND due <= 7d

With that being said, it is always a good option to try the simple search first and adjust the resulting JQL like @Bogdan Gorka explained.

Regards

Bogdan Gorka

Thanks @Merve Nur Bas I have learnt something too.

To exclude overdue issues I would normally use due >= "0" AND due <= 7d but I am not sure if the the "0" means start of the day or the moment the JQL is executed. So, to be 100% sure, it is better to use startOfDay().