JQL for issues due in less than equal to 30, less than equal to 60, less than equal to 90 days

[Adrienne McCoy]

Hello,

I am trying to write the queries for issues that are due less than equal to 30, less than equal to 60, and less than equal to 90 days out. This is based off of a date picker field.

I'm trying to add those into Swimlanes on my kanban board, so I cannot have duplicate issues in the filters.

I'm struggling to write the JQL, and every time I write the queries, only one of the swimlanes appears on my board.

Any help is much appreciated!

[Nic Brough -Adaptavist- · Accepted solution]

The JQL you need is based on the relative date selection, so at a glance, you need

my-date < +30d

my-date < +60d

my-date < +90d

Problem for swimlanes though is that the +90d line will include the issues in the other two (and the +60d one will include the issues from the +30d)

So for swimlanes, you probably need

my-date < +30d

my-date < +60d and my-date >= +30d

my-date < +90d and my-date >= +60d