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?
Community moderators have prevented the ability to post new answers.
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..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.