nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to Work with JQL while Developing Report?

tousifs

I am Developing a Report where i want to calculate time spend by each user for each issue please guide me.

Accepted answers

JamieA

Why reinvent the wheel - see https://studio.plugins.atlassian.com/wiki/display/TIME/JIRA+Timesheet+Plugin.

All comments

JamieA

Why reinvent the wheel - see https://studio.plugins.atlassian.com/wiki/display/TIME/JIRA+Timesheet+Plugin.

tousifs

can i get the source for same which i can extend

JamieA

Can you look at the link I sent, you will see a link to the source.

tousifs

thank's it fulfil my requirement.

Contact Kintosoft

Well. people reading this post might be also interested in the SQL for JIRA plugin as it is able to make such reports seamlessly:

select ISSUEID, SUM(TIMESPENT) as "Effort"
from ISSUESWORKLOGS
where
 CREATED &gt;= PARSEDATETIME('2014-01-01','yyyy-MM-dd')
and
 CREATED &lt;= PARSEDATETIME('2014-12-31,'yyy-MM-dd')
group by ISSUEID
order by 2 desc

Of course, you might want to group by user or any other JIRA data by using the SQL join feature. The plugin is really quite powerful and flexible and it supports any JIRA entity like projects, versions, custom fields, etc.