Help with this JQL query.

How can i get a jql query for getting all the issues which are older than 2 years.

2 answers

1 vote

To search for issues created over two years ago:

createdDate < -104w

To search for issues that were last updated over two years ago:

updatedDate < -104w

You would probably want to add "AND resolution = unresolved" to filter out the older resolved issues.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

1 vote

Depends on how you define "older", as you could mean any of created, updated, commented, transitioned etc.

But something like

updated < -730d

should do it.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

do you have something like createdDate < -2y

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.