nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

All comments

Ramaiah Pendli_e9undi

Hi Shiva,

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

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.

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 .

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.

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

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.

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

rest-api

jql

tempo-timesheets

worklog