Finding the issues that have never been updated

[D PK]

I want to find all the issues that haven't been updated since they were created. I was thinking of writing a filter that has updatedDate = createdDate but it's not possible to do that in JQL. How can I do this and is there a better way of finding the issue that haven't been updated ?

[Udo Brand · Accepted solution]

hmm, the closest I can think of is searching for issue where the status never changed.

not status changed

[D PK]

That's a very good alternative but is there a way to compare updatedDate and createdDate in JQL?

Thanks.

[Udo Brand]

I'm afraid you can't compare two fields in JQL

[Manuel Dalle]

How about this:

not updatedDate < now()

[Filipe]

Hi,

Please give a try on :

https://marketplace.atlassian.com/plugins/pt.lt.lfcribeiro.jira.jqlLTFunctions

IT will let you run SQL functions, using JQL functions - > executeQuery()

Thx,