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

Fitler to Track issues where a user did not track time

John Anderson_k4guox

I am looking for a filter that will list issues that are or were at one time assigned to a particular user on a given day but that user did not log any work.

Example: User X had 5 issues assigned to him today, he only logged work on three of the issues. I want the filter to pull in the other two issues where the user did not log time. These issues may have had time logged by other users but not the user I'm tracking.

Here is a filter that I created which sort of works. Thsi filter pulls in issues the user did not log work on but breaks when others log time on the issue.

status was "Status" by user AND createdDate >= startOfday() AND worklogDate >= startOfDay() and worklogAuthor != user

Accepted answers

All comments

Elifcan Cakmak

Hello,

I tested and noticed that worklogAuthor != user works only if somebody else logged on the issue. If nobody logged work, then it doesn't show the issue on the list.

If you have script runner plugin then you can write something like this:

issueFunction not in workLogged("by elifcan") and (assignee was in (elifcan) AFTER startOfDay()) and status = "Work in progress"

I tested it and if I did not miss anything, it seems working as you wish.

Regards,

Elifcan

John Anderson_k4guox

Thanks for this but I'm still struggling. The AFTER startOfDay()) does not seem to be working as this is pulling in issues going back in time

Elifcan Cakmak

Hello,

I couldn't understand what you mean by "as this is pulling in issues going back in time" but you can change the AFTER startOfDay() as you wish. For example you can use ON '2018/12/12' for specific days. This means on 2018/12/12 the assignee was that user and that user was not logged in by that user. Does something like this work for you?

Regards,

Elifcan

John Anderson_k4guox

I'm only looking for issues from today where a specific user did not log time on the issue. I do not want to use a date because I want to use this filter over and over and not have to adjust the date in the filter each time. The problem I'm having with the one listed above is AFTER startOfDay()) I would think would look for any issues after the start of that given day. My problem is it is looking at all issues going back in time, not just for today. I have tried changing it around and just receive errors

John Anderson_k4guox

think I may have it now.. I changed the time to and created >= startOfDay() and it now seems to be working the way I would like. thank you both for your help!

Elifcan Cakmak

Hey, yes that's what I was gonna suggest next after reading your comment glad it helped.

Cheers.

John Anderson_k4guox

Thanks again! This was very helpful!

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

filter

tempo

time-tracking

worklog