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.

[JamieA · Accepted solution]

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.

[Pablo Beltran]

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 >= PARSEDATETIME('2014-01-01','yyyy-MM-dd')
and
 CREATED <= 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.