How to get worklog time spent by user in a project on a specified date range via JQL

[Shiva Gaire]

Hi all,

I would like to get a work log time spent by a user over a specific date range

For example. If a user logs work in a project ABC in date 2019/1/18, but he logs work for the date of 2019/1/2. How can I get how much the users have spent time on the project in the date range 2019/1/1 to 2019/1/7?

Thank you in advance for your help.

[Rambabu Patina _Appfire_]

Hi @Shiva Gaire, Welcome to the community.

Have you tried the below JQL:

project = <project_key>   and worklogAuthor = <author> and worklogDate >= "2019/01/01" and worklogDate <= "2019/01/07"

And let us know.

Thanks,
Ram.

[Shiva Gaire]

Hi, Thank you for your response.

I did the same however I want to get the time spent via aggregateExpression or something like that, not just the total time spent from the beginning.

project = ST  and worklogDate >= "2019/01/10" and worklogDate <= "2019/01/12"  AND issueFunction in  aggregateExpression("Total Estimate for all Issues", "originalEstimate.sum()", "Remaining work", "remainingEstimate.sum()", "Total Time Spent", "timeSpent.sum()")

I got the following output. 

Remaining work:0 minutes

Total Estimate for all Issues:0 minutes

Total Time Spent:2 days, 3 hours

But, what I want is the time spent only for the duration I mentioned but not the total time spent aggregated from the very begining. I have script runner and tempo as plugins

Time Spent: 6 hours

Remaining Work: <n> hours

IS there any way to get like this. Your help will be highly appreciated.

[Tom Hawkins]

Hello, we've been facing similar, https://community.atlassian.com/t5/Jira-questions/Re-Jira-TimeSpent-query-for-the-users-who-logs-hours/qaq-p/1825128/comment-id/504005#M504005 might be of interest, thanks Tom 

[Piotr Bojko]

With Smart QL you can do following queries:

SELECT * 
FROM WORKLOGS W
JOIN AUX.JQL('ID','PROJECT = ABC') JQL ON W.ISSUE = JQL.ID
WHERE W.STARTDATE BETWEEN ? AND ?
AND AUTHOR = ?  

you can further modify such query to have summaries, per day, etc or even place the data on a dashboard chart .

[Andy Heinzer]

@Piotr Bojko Thanks for contributing an additional possible solution here.  However in the future, please review our Atlassian Community guidelines for Marketplace vendors and Solution Partners.  Specifically, we would prefer that you identify yourself as being affiliated with the plugin/app in question before recommending it.  Thanks.

[Piotr Bojko]

Ouch sorry for that. For sure I am affiliated with the mentioned app. I will make my best to be more political correct.

Again, sorry for that.

[Ramaiah Pendli]

Hi Shiva,

Use the Tempo Timesheets add-on track the user/team time logs for a specific time frame. 

[Shiva Gaire]

Hi, Thank you for your response.

I am able to get the desired output in the UI for the specific JQL filter I have using the tempo timesheets. But I am looking for the API or JQl alternative that can be run with scriptrunner.

I am unable to find any help from this API docs.

Your help on this will be highly appreciated