Jira should get highlighted if comment added is 2 days old

Question

My objective is to highlight Jira's with different color in current sprint in which comment is not updated since 2 days.

I have used query in Board -> Configure -> Card Colors section

updated < -2d AND status not in (Closed). But this query is not giving desired results

Daniel Turczanski - JQL Search Extensions · Answer

Hi @Siddharth Singhal ,

You can find tickets that were not commented in the last 2 days with our indexing service

* JQL Search Extensions

After you install the app you can create a filter "commented in the last 2 days":

commentsCount > 0 AND commentedOnDate > -2d

Then you can create a JQL query that returns the tickets that were not commented in the last 2 days:

commentsCount>0 and filter!="commented in the last 2 days"

You can use this query to color your cards. Make sure to check out the documentation.

I hope it helps!

Daniel

Daniel Ebers · Answer

Hi @Siddharth Singhal

in the past I came across use cases where for this "JQL Tricks" were used.
This was back on Jira Server, however I read this App is now also available on Jira Cloud.

Just please be noted the App is a paid one - it might depend on if you are willing to get an extra App if this is a match at all.

Alias to find issues based on the date when a comment was last created on the issue. Date should be in yyyy-mm-dd format. Supports relative dates as well.

https://www.j-tricks.com/jqlt-cloud-usage.html

As you mentioned boards I cannot confirm right away that this will work the way like you intend it to - this is an additional requirement I am not familiar with.
The documentation suggests it would be possible.

You can always try apps for some days without cost. In case this sounds useful you could give it a try.

Cheers,
Daniel

Nic Brough -Adaptavist- · Answer

That query will return issues that have not been updated in the last two days and are not closed.

I have paraphrased to confirm my understanding of what you are asking, because I am not 100% sure I understand.

Anyway, assuming I have understood, what happens if you run that query plain, outside a board?  Could you try it combined with the board filter, just to see what you get back?  I mean, if the board filter is "Project = XYZ", then what list of issues do you get when you search for "Project = XYZ and updated < -2d and status not in (closed)"?

If it returns an issue that should be coloured red on the board, then can you check whether the card appears on the board in red?  If it does not, then can you take a close look at the issue (ideally, screenshot part of it and post it here - we'd want to see the updated date, the status and the project key part of the issue - crop or obscure anything else that you might not want us to see)