nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter on when an issue was commented on.

Stu_pdqfrd

Hi, I keen to get some JQL for a Quick Filter that will enable me to display which issues haven't had a new comment added to them for 20 days.

Any thoughts?

Thanks in advance

Accepted answers

Nir Haimov

Hi,

This:

!(commentedOn >= startOfDay(-20))

Will give you all issues that have comments, but not in the last 20 days.

If also want issues without comments at all add

commentedOn is EMPTY

So your funal JQL is:

!(commentedOn >= startOfDay(-20)) OR commentedOn is EMPTY

All comments

Nir Haimov

Hi,

This:

!(commentedOn >= startOfDay(-20))

Will give you all issues that have comments, but not in the last 20 days.

If also want issues without comments at all add

commentedOn is EMPTY

So your funal JQL is:

!(commentedOn >= startOfDay(-20)) OR commentedOn is EMPTY

Johan Soetens _Dumblefy_

Very handy but commentedOn is not an out-of-the-box feature, it's from Adaptavist Scriptrunner

Nir Haimov

Yeah, forgot to mentioned it, there is no built in solution in Jira, you can achieve this only with add-ons, Scriptrunner is one of them

Stu_pdqfrd

Great - thanks guys, I already have ScriptRunner. cheers

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-cloud

jql