I want to search for Items that have not been updated since they were created

[Michiru Yanagishita]

lastViewed <= created

is not good.

How I do？

[Ste Wright]

Hi @Michiru Yanagishita 

Natively, there's not a method to compare updated and created I don't believe.

You could get close to what you're looking for - for example, look for issues that were created in the last 7 days but not updated within the last 6 days:

createdDate >= -7d and NOT updated >= -6d

 Or with a date:

createdDate >= 2020-08-01 and NOT updatedDate >= 2020-08-02

You can also look for issues which have had no status changed:

NOT status changed

If you want to compare the two fields themselves, you'll need an app - like Scriptrunner - which can offer more advanced JQL functions.

Then you can use a function like dateCompare - see more about this function in their Knowledge Base.

Ste

[Michiru Yanagishita]

Thank you. I will try.

[Michiru Yanagishita]

Is it possible to search for a comment not mentioned?

[Ste Wright]

Hi @Michiru Yanagishita 

Are you looking for issues with no comments?

Again, this isn't one available natively. You'd need an app to search for that kind of query.

Ste

[Michiru Yanagishita]

I　see. Thank you.