Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Fitler to Track issues where a user did not track time

John Anderson January 16, 2019

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 

7 answers

2 votes
Elifcan Cakmak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 17, 2019

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

1 vote
Elifcan Cakmak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 17, 2019

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

Cheers. 

1 vote
Elifcan Cakmak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 17, 2019

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

0 votes
John Anderson January 17, 2019

Thanks again! This was very helpful!

0 votes
John Anderson January 17, 2019

 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!

0 votes
John Anderson January 17, 2019

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

0 votes
John Anderson January 17, 2019

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

Suggest an answer

Log in or Sign up to answer