Get pivot report with JQL

Maksym Saichuk October 9, 2012

I need to get all worklogs at some date or in some range of dates for my Java application. Now I'm getting issues that where updated at some date, but I can't get issues where worklogs where added beforehand. Is there a JQL query to get all those issues with worklogs in some range of time? Maybe there is another way?

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Pablo Beltran
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 1, 2015

You could achieve it in a straightforward way by using the SQL for JIRA plugin which transforms JIRA in a virtual database server, so you are able to use JDBC + SQL from your Java application and execute the query below, for instance:

select AUTHOR, 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 AUTHOR
order by 2 desc

It will summarize the efforts for each user during the 2014 year. It also takes in consideration the privileges of the logged in JIRA user performing the SQL query accordingly to the PROJECT ROLE of the worklog record if it was set by the author's worklog..

 

 

TAGS
AUG Leaders

Atlassian Community Events