Needs ideas for a JQL Filter that displays zero time logged for the current day...

[steve_josue]

I need ideas for a JQL Filter that displays zero (empty) time logged against ACTIVE work items assigned to that user for that current day.....Preferably a list of all users that have zero hours logged for all their active work items.

[Trudy Claspill]

Hello @steve_josue 

JQL is designed to get you a list of issues, not a list of users. It also is not designed to get you a list of worklogs.

Are you open to third party apps?

Without apps you can get a list of issues for which time was logged today. You would then have to extract manually from that who made the time log entries. You would then need to manually compare that to a list of all the possible people who could've logged time today to determine who did not do so.

[Marc -Devoteam-]

A BI app would help here to get the data out of Jira and into a BI tool.

Or try to use Atlassian Analytics, as your tags mention you are on a Enterprise plan.

[arielei]

Hey @steve_josue 

If you are running the jql every day then you can try use "worklogdate = -1", this should return all work-items that last got updated a day before and not in the current day.

Then, you can either create a filter with only the assignees or an automation to fetch the assignees into an array and then send it out.

Hope that helps.

Ariel.

[steve_josue]

Hi  Arielei,
I tried using the query below and it worked - sort of:

Project in ABC AND Sprint in openSprints() AND timespent = 0h AND updated >= startOfDay("-1d")

The problem with this query is that it assumes the assignee is updating the ticket (ie with a comment, etc.) but not necessarily logging time and I did fine one record. However, we need all active tickets from that day whether updated/commented or not, that have 0 hours logged. Any ideas? TIA!

[Trudy Claspill]

Hello @steve_josue 

What is your definition of an "active" ticket? Is that based on the status of the ticket?

Also, the "timespent = 0h" is selecting issues where no time has been logged ever. That does not select issues for which no time was logged specifically on the day the query is executed.