How to sum the "timespent" per user

[Jarosław Dudziński]

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]

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]

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