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; } } }

JQL expression for: "open issues with no activity of assignee <= -14days"

Markus Flaig1

Hi,

I need to find Issues where the last activity (e.g. comment) of the assignee is 14 days or older. I currently use this jql query:

assignee = "asssigne" AND (status = Open OR status = Reopened OR status = "In Progress") and updated &lt;= -14d ORDER BY created ASC

But this only shows tasks which have no activity at all within the last 14 days or older. I need to know if a supporter ignores issues even if the reporter keeps posting comments. Comments by the reporter count as an activity which removes those issues from the above query.

So, is there any way to express:

"last activity of assignee <= -14d"?

Cheers,

Markus

Accepted answers

Markus Flaig1

First of all, thank you for your answers!

@Renjith: Unfortunately your suggestions does not work for me, since some of our support customers are also jira-developers, as JIRA is used in-house only. I needed to pinpoint if the assignee of a task ignored begging customers, regardless if the customer is a jira-dev or not.

@Nat Hobson: Your plugin hint eventually helped, I stumbled over the jql-tricks plugin which brings the function "commentedByUser("username")".

My jql query looks like this now:

assignee = "&lt;insert_assignee&gt;" AND (status = Open OR status = Reopened OR status = "In Progress") and updated &lt;= -14d and issue in commentedByUser("&lt;insert_assignee&gt;") ORDER BY updated asc

Cheers,
Markus

All comments

Natalie Hobson

Your 'assignee = "assignee" isn't actually do anything, essentially your query is:

status in (Open, Reopened "In Progress") and updated <= -14d

which will show you any issues that are in one of those three statuses and have not been updated in the last 14 days. Currently JIRA doesn't support searching "updated" in conjungtion with another value (like in your example, if supported I would imagine it would be something like "updated <= -14d by user = assignee").

There might be a plugin which would extend the possibilities of "updated", however.

Renjith Pillai

Add the Toolkit plugin - https://studio.plugins.atlassian.com/wiki/display/JTOOL/JIRA+Toolkit+Plugin
Add the field "Last commented by a User Flag"

In your JQL add an extra argument "Last commented by a User Flag" = true

Markus Flaig1

First of all, thank you for your answers!

@Nat Hobson: Your plugin hint eventually helped, I stumbled over the jql-tricks plugin which brings the function "commentedByUser("username")".

My jql query looks like this now:

assignee = "&lt;insert_assignee&gt;" AND (status = Open OR status = Reopened OR status = "In Progress") and updated &lt;= -14d and issue in commentedByUser("&lt;insert_assignee&gt;") ORDER BY updated asc

Cheers,
Markus

Natalie Hobson

Awesome! If you wanted to clean that up a bit, you could replace your OR statements with an IN statement:

assignee = "<insert_assignee>" AND status IN (Open, Reopened, "In Progress") and updated <= -14d and issue in commentedByUser("<insert_assignee>") ORDER BY updated asc

EddieW

or just "Resolution is EMPTY" for all unresolved tickets.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

jqlquerybuilder