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

Is there a JQL that shows me tickets that are due in next two weeks?

anjani.kava

My Kanban board has tickets and instead of creating a sprint, I just want to create a filter that will show me tickets are due in the next two weeks.

Accepted answers

Hana Kučerová

Hi,

you can create filter using JQL looking something like this:

duedate >= now() AND duedate <= endOfDay("+14")

All comments

Hana Kučerová

Hi,

you can create filter using JQL looking something like this:

duedate >= now() AND duedate <= endOfDay("+14")

anjani.kava

Thankyou. This worked

anjani.kava

@Hana Kučerová - apart from the above can you also help me create a filter that shows me tickets that are past the due date and not updated/closed.

Hana Kučerová

duedate < now() AND resolution = Unresolved

This JQL will show all overdue tickets, which are not resolved (field Resolution is empty).

It could work, but maybe you will need something more specific. I'm not sure about "not updated" - does it have any special meaning? Do you always fill in the Resolution field, when you resolve the issue?

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

jql

filter

due-date