JQL Query Filter: Find time spent for issues with multiple Work Log Authors

[Kay Price]

I'm trying to find a way to filter how to accurately find the amount of time a user spent within the last 30 days, for issues with and without multiple work log authors. I want to use this filter to for a gadget within the JIRA Dashboard.

I have tried: project in (<PROJECT>) AND worklogDate >= '-30d' AND worklogAuthor = <user>

Problem: The issue with this is within the Dashboard, it will calculate the total amount of hours spent for the whole issue total, instead of the just the logged work for that particular user. 

Then I tried: project in (<PROJECT>) AND updated >= '-30d' AND assignee in (<user>)

Problem 1: This will only the count the hours for the person who is assigned to the issue. So if multiple users worked on that issue, it will count all the hours, instead of just that one person. 

Problem 2: Since it is only looking for the assignee, it will not count the hours the user has spent on an issue, even if they have logged hours, because they are not the assignee. 

Does any one have any advice, aside from purchasing another plug-in?

[Alexey Matveev]

If you have Power Scripts or ScriptRunner plugins then you could write your own JQL function.