How to sum the "timespent" per user

Question

Hello,
I need to sum "timespent", monthly, per projects, by every team member, preferably using filters (JQL)
But - as I can see - the aggregation is performed per task, so I can total timespent per task, even if there were two or more people registering work_time.
E.g. If A registered 2 hours, and B registered 4 hours (and the task is actually asigned to B) , I will get 6 hours assigned to B.
Is there any way to change that, so I can get "A - 2 hours, B - 4 hours" in filter?

Piotr Bojko · Answer

With SmartQL - https://marketplace.atlassian.com/apps/1218767/smart-ql-sql-jql-easy-reporting?hosting=server&tab=overview - you can write, more or less following query:

select jql.project, w.author,  sum(w.timeworked) rawworked,  AUX.ASDURATION(sum(w.timeworked))) prettyworked
from table(AUX.JQL('id, project','your-preferable-jql') jql
join worklogs w on jql.id = w.issue
group by jql.project, w.author

Nir Haimov · Answer

Hi,

The quick answer is no, you can't.

You will have to write code that will give you the result you want.

You can write your own plugin, or more simple, using groovy with ScriptRunner