Can I filter out completed issues without logged work/time against them?

[Léonard Texier]

Hi,

I'm trying to track/filter out Sub-tasks or Deliverables set as For Review or Complete where team members have forgotten to log time against... Any ideas? 

Working with JIRA v7.2.6, Portfolio for JIRA v2.2.2 and JIRA Agile v7.2.8-DAILY20161130154106

Cheers,
Leo

[Gaston Valente · Accepted solution]

Try this:

(issuetype in subTaskIssueTypes() or issuetype = Deliverables) and timespent is empty and status in ("For Review",Complete)

[Léonard Texier]

Thanks guys, both works great!

I added originalEstimate is not EMPTY to filter out issues without Estimate as well:

issuetype in (Deliverable, Sub-task) AND status in (Complete, "For Review") AND timespent is EMPTY AND originalEstimate is not EMPTY

[Thomas B]

Awesome!

[AKBAR]

Hey @Léonard Texier 

I am also getting issues with logged time using this jql.. we use tempo for logging time.. am i missing?

[Dhouha Kallali]

Hello Akbar,

I am also having the same situation as you.

I would like to filter issues with no logged time using Tempo Timesheet. Any ideas ?

Thank you

[Andriy Zhdanov]

Hi Dhouha,

Try to use filter created in Advanced Issues Search with JQL: resolved is not null and timespent = 0

Thank you.

[Dhouha Kallali]

Hi Andriy,

Thank you so much for your help. It's working but it doesn't display all unlogged issues.

I'm using JIRA Cloud btw

[Dhouha Kallali]

Never mind. 

It's working while using "timespent is EMPTY".

Thank you very much for your help

[Thomas B]

Gaston's should work. If not try this

issuetype = Sub-task or issuetype = Deliverables AND status = For Review or status = Complete AND timeestimate = 0