JQL to run at end of every quater

[Piyush_Annadate]

Hi All,

Is it possible to run a JQL/ retrieve list of issues/tickets at the end of every quarter.

I do have scriptrunner installed and see Escalation service as an option. But that would require a JQL for it - Do we have that kind-of feature to list ticket which are open and let them close at the end of quarter?

[Ivan Tovbin]

I think you should try something like:

created >= startOfMonth(-3) and resolution is empty

[Piyush_Annadate]

hi,

That won't be good here as it won't be good to know about the current quarter. 

[Ivan Tovbin]

Well then if the search is run AFTER the quarter has ended then I think this should work:

created >= startOfMonth(-3) and created <= endOfMonth(-1) and resolution is empty