how to display a sum of timespent(worklogs) from jira issues in confluence

[Michał Schielmann]

I would like to display a sum of time spent on few Jira tickets(with the same custom field value) in confluence. I can make a query in jql and select those tickets and use Jira Issues Macro to display them with corresponding timespent field. But the results are displayed in a table and not as a sum - and i would like to get only one number(minutes, hours).

Is there some other plugin, macro that i could use? Would Confluence SQL Plugin solve this problem?

[Sergey Papurin · Accepted solution]

Confluence SQL Plugin will help you

[Michał Schielmann]

hi Sergey,

thanks for the answer - i'll try my luck with sql plugin then

[Sergey Papurin]

Update - you can config applications links between Jira and Confluence, then add gadgets to page in Confluence