How to find issues without existing worklog

[Anna_Kuzub]

I have a big amount of issues and it is necessary to find issues without worklogs. Is it possible to do it?

[Jack Nolddor _Sweet Bananas_]

Hi Anna, as @Ashkan Malekly already suggested you can find issues without worklogs by typing the following using the Advanced Search feature:

timespent IS EMPTY

As you notice the above query does not discard issues having subtaks with worklogs. Sadly, there is no a native way to query those issues. You must go for a third-party app instead. Using i.e. JQL Booster Pack (Server) you can type the following:

Find issues without worklogs on it and any of their subtasks

timespent IS EMPTY AND issue NOT IN parentsOf("type IN subTaskIssueTypes() AND timespent IS NOT EMPTY")

Note that this is just an exaple, probably you must tune your query to fit your needs

References:

• Official documentation

Hope this helps you to create awesome queries <3

Kind regards

[Muhammad Ramzan(Atlassian Certified Master)]

If you want to get only parent issues without time log use this query. this one can be achieved without any plugin.

timespent is EMPTY

To get these you must need a good plugin like JQL Search Extensions for Jira & reports  

if you want to get only those parent issues where time is logged in their sub tasks.

issue in parentOf("timespent is EMPTY")

if you want to get all issues where time is not logged including parent and their subtasks.

issue in parentOf("timespent is EMPTY") and timespent is EMPTY

[Ashkan Malekly]

Hi @Anna_Kuzub 

In jql advance mode write this:

Timespent is empty

[Anna_Kuzub]

Thanks, it works only if time has not been logged to the issue. But sometimes time has been already logged to sub-task added to the issue. Unfortunately, I need to find issues without work logs on the issue itself and on the related sub-tasks 

[Ashkan Malekly]

So I think you can search like:

Issefunction in subtasksof(“project =xxx and issutype = task and timespent is empty)

Maybe this work. I don’t access to computer right now but if it doesn’t work tell me I would find the query in about 5 hours later.