Return true if work has NOT been logged in the last 24 hours?

merritta87

Every day we hold a meeting to discuss the work we are working on, look at a burn down chart, and go over how much work is left over. This becomes difficult when people do not log their time daily to the tickets they are working on. 

So, is what I want is a query that sets the "card color" to say, red, if work has NOT been logged in the last 24 hours. I have tried:
NOT worklogDate() > -1d
Which I would assume would return true if work was not logged in the last 24 hours. Which would then set the card color of that entry. But all that does is check for issues with comments in the work log entries outside of the past 1 day. So, if a user has logged time for Monday and Tuesday, but not Wednesday and today being Thursday it doesn't work it returns a false because it found work logs. 

So, how do I get my card color to change based on my example above? 

Andy Heinzer

Hi Aaron,

I think I understand what you are looking for here, but there is another possibility here that the issues could have another value besides >, <, or = to worklog values:  NULL.  That is to say issues that have never logged any work at all will still not be returned by your current JQL query.

Instead I'd recommend keeping your existing NOT query, but then also adding in the inverse query without the NOT operator to look like this to start:

(worklogDate <= -1d AND NOT worklogdate > -1d)

Because it's possible that issues have lots of different worklog entries, and

 

But then in order to check for issues that don't have any worklogs at all, you can use the

timespent is empty 

And you can put these together with an OR statements so in the end you can use something like:

(worklogDate <= -1d AND NOT worklogdate > -1d) OR timespent is empty 

 

This way you should be able to create a single query that shows both the issues without recent worklogs and those without any logged time on them.  In my testing I wasn't able to reproduce this problem you mentioned in regards to whether or not a comment is left on the worklog.  At least in my testing the same number of issues were returned here for me regardless of whether or not they had a comment in that worklog itself.

 

Let me know if this helps.

Regards,
Andy