Why does filter where worklogDate() = endOfDay() not work in dashboard gadget?

Question

I am attempting to apply a filter to the workload pie chart dashboard gadget to show me only workload time that was logged for today. Using worklogDate() = endOfDay() would make me think I should be getting the sum of "Time Spent" where the "Date Started" field from the Log Work panel equals today.

When I use the filter worklogDate() = endOfDay(), I see issues that have time logged today, but the instead of only time where the Date Started field equals today, I get the sum of all time on those issues.

How do I craft my JQL filter to give me the results I need (only time logged for today) in the Workload Pie Chart dashboard gadget?

Lisa Lawrence · Answer

Thanks, Branden, but this does not answer my question. I am attaching a screen grab from today of the widget where I have a subtask with time (1h 15m) logged each for today, yesterday, and the day before. The filter I am using is exactly: worklogDate = endOfDay() AND worklogAuthor in (currentUser()).

You can see in the pic that the total time is 3h 45m, which is the total time allocated to this subtask for all three days. Why would I see all the time logged, regardless of the date it was logged to or the date the worklog was created?

I am using JIRA's native time tracking, so there should be no complications on that end.

Lisa

somethingblue · Answer

Hi Lisa,

I have three issues with logged time:

* KANCARDS-1: 54 Minutes
* FNGME-8: 6 Minutes
* AS-1: 25 Minutes

AS-1 has worked logged from yesterday and doesn't show up in a jql search when I use worklogDate = endOfDay().  In addition, the two issues show up in the chart as follows:

As you can see the time is coming from the Logged field under Time Tracking on the right side of the ticket:

Hopefully that clears things up a bit.  If not let me know what you're trying to do and we'll go from there.  If you're not using JIRA's native time tracking let me know what add-on you're using for Time Tracking, e.g. Tempo Timesheets, etc.

Cheers,

Branden