How do you get worklog for specific date range (without using a plugin)?

Hansol Lee_vnaqef

e.g. I have a user named foo.bar who has logged following number of hours on a ticket:

- 4 hrs on Jan 29, 2019
- 4 hrs on Feb 2, 2019
- 2 hrs on Feb 4, 2019

Is there a way to get ONLY the number of hrs logged in Feb?  

I've tried:

worklogAuthor=foo.bar and worklogDate >= 2019-02-01

...which returns the correct ticket, but both "ΣTime Spent" and "Time Spent" show 10 hrs, instead of 6.

I tried looking for another column name that may contain the info I'm looking for but no avail.

 

Jobin Kuruvilla [Adaptavist]

Unfortunately, you will need a plugin for this. Plugins like Tempo can create reports you are looking for and plugins like JQL Tricks can pull the issues using JQL.