CODEWITHSUNDEEP
jirajql
akashmkr6
akashmkr6

Reputation: 170

How do I query Jira to search for all issues in a project for which no user has logged work in last week?

I need a way to get all the issues (which are not resolved or closed) of a particular project for which no user has logged work in last week.

For example, let's say I have a project = 'abc' with five issues 'i1', 'i2', 'i3', 'i4' and 'i5' and there are two users 'u1' and 'u2' who can log work in these issues.

Last week - 'u1' logged work in issues 'i2' and 'u2' logged work in issues 'i2' and 'i3'.

So the desired result is - 'i1' and 'i4'.

Upvotes: 1

Views: 4200

Answers (2)

Mike Britton
Mike Britton

Reputation: 317

Something like

project = ABC and status not in (Resolved, Closed) and worklogDate > startOfDay(-7)

should work.

Upvotes: 1

Scott Dudley
Scott Dudley

Reputation: 3298

You can do this by installing the Script Runner plugin and using JQL to query for workLogged information:

project=ABC and status not in (Resolved, Closed) and issuefunction not in worklogged("after -7d")

If you need to do fancier queries based on the attributes of the users and so forth, see the commented() documentation for reference.

Upvotes: 0

Related Questions