Retrieve time log entries within a given date range for tickets in a project (JQL/Rest)

Rob Davis November 18, 2016

I need a JQL/Rest API query to find all time log entries in a date range for tickets on a project.

I'd like to find a solution that does not require a plug-in or developingmy own, if possible.

Is this possible in JIRA (without plugins) via JQL/Rest API? I am using JIRA 6.1

 

Research so far

I have looked at the REST documentation and not seen a query that does this, so far: https://developer.atlassian.com/static/rest/jira/6.1.html

 

Only found solutions, so far, that involve plug-ins

on plugins

https://answers.atlassian.com/questions/212002 - solution to use JQL Tricks Plug-in ( https://marketplace.atlassian.com/plugins/com.j-tricks.jql-plugin/server/pricing ) (but appears to be available for JIRA 7, not sure if supported in JIRA 6.1)

https://answers.atlassian.com/questions/38852966 Tempo Plugin

 

on developing own plug-in

https://answers.atlassian.com/questions/238866 - develop a plug-in

 

 

 

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.
November 18, 2016

If finally you use 3rd party plugins you might want to have a look at the SQL for JIRA Driver. It allows to combine JQL and SQL and perhaps (over HTTP) which is quite powerful than REST.

Even you might be lucky with the  Data Analysis Console if it matches your requirements out of the box as it allows to analyze users' worklogs in a friendly way with support to export to CVS, Excel, etc... and using a JQL as input of course.

Rob Davis November 18, 2016

Thank you. I will do some more research on REST in parallel with this question. If I conclude that there is no REST in the basic JIRA install then I will accept this answer.

TAGS
AUG Leaders

Atlassian Community Events