JSL code to create a filter showing tickets created between 8-20 days

[jace.jones@envestnet.com]

I track the tickets in my products by age of create date (created in the last 7 days, 8-20, and more than 21 days).

My filters never equal the total amount of all open tickets in the queue.  Should they since all the creation dates will fall within the time frames and resolution is unresolved?

[Emre Toptancı [OBSS] · Accepted solution]

Hello jace.jones@envestnet.com

You can divide your ticket into JQL queries like below:

• project = ABC and created >= -7d
• project = ABC and created < -7d and created > -20d
• project = ABC and created < -20d

These three JQL queries should divide your issues into 3 groups as you mentioned. They should also cover all the issues in ABC project, leaving nothing out.

EmreT

[Emre Toptancı [OBSS]]

One thing to be careful about here. Giving only the date is not enough.

-7d means 7 x 24 hours before this very moment. If my current date and time is "Feb 15th, 2022 14:30" then -7d means "Feb 8th, 2022 14:30". So it is a constantly moving time window.

[jace.jones@envestnet.com]

Thanks Emre.  These worked precisely as needed. 

[Mark Segall]

Hi jace.jones@envestnet.com and welcome to the community!  Can you please share the queries you're using?

[jace.jones@envestnet.com]

Here is what I using.

created <= -3w AND project = USHD AND resolution = Unresolved ORDER BY assignee ASC