Filter all issues since the oldes not closed issue

Question

Hi!

I need a filter that returns all issues that have been created since (or after) the oldest issue in the project that has not yet been closed / resolved.

Something like:
project = PROJECT1 AND Created > ( Created of the oldest issue with Status != Closed )

Any ideas?

WM_y43pr5 · Answer

Hi @Callum Carlile _Automation Consultants_

thank you for the quick reply.

Unfortunately the last paragraph is what I am looking for. Filter for all the fields works fine. But..I am just looking for all issues regardless of their status or resolution, within a relative period of time, starting with the oldest unresolved ticket until today.

So there is no filter for that, I guess?

Callum Carlile _Automation Consultants_ · Answer

Hi @WM ,

You can achieve this by using the resolution field. By default, statuses like Done and Closed should automatically set issues to 'resolved' (you can also create custom statuses and custom resolutions to do the same).

You could use the filter of: project = PROJECT1 AND resolution = resolved ORDER BY created ASC

Here, you can replace 'resolved' with any set list of resolutions, in the format of ("res1", "res2", "res3"....). This will remove all issues which have been resolved from the filter, so adding the 'ORDER BY created ASC' will order the list displaying the oldest unresolved issue first.

You can filter the resolution date by a date range, or 'within the last/more than x mins/hours/days/weeks ago', but unfortunately can not set this range based off the resolution date of a specific issue.

Hope this helps!