Sum of time spent for specific time period

[Armitha Reddy Toorpu Ceema]

 I only want 15 days of worklog for a ticket even though it has 30 days of work .

Note:- please suggest JQL query for this.

[RVS_Support]

Hi @Armitha Reddy Toorpu Ceema 

As this would not be possible with plain JQL, the options would be call Jira Rest API's and write a custom logic or get a mktplace app for a readymade solution.
If you are open for the latter, you can try out our add-on. And track time spent by resources with multiple filters / category / grouping features, including date range filters.

Worklogs Time Reports

Disclaimer : I am part of the app development team

[Starware]

Hi,

You are asking for JQL query for worklogs. JQL query can only return issues, not worklogs. Only thing you can do is querying issues which has at least one worklog within the past 15 days. But returned issues may have additional worklogs for any other times. If you want, you can open the issues one by one and sort the worklogs according to start date. But most time tracking apps in the marketplace can allow you to display worklogs only in a specified time frame. As a vendor, I can recommend our own app WorklogPRO - Timesheets for Jira.

[Sreenivasaraju P]

Hi @Armitha Reddy Toorpu Ceema ,

Do you want the worklog for 15 days? If yes, you can try worklogDate  option in the query. 

ex:

project = "project name" AND worklogAuthor = "whose work log you want "AND worklogDate >= "2023/09/01" AND worklogDate <= "2023/09/15"

[Armitha Reddy Toorpu Ceema]

Hi Sreenivas,

If I run the above JQL Query which you have provided above it was showing total amount of time spent up to the date which we have provided in query.

But all I want is to get worklog specifically only for 15days not for the total days from when ticket is created.

Thanks & Regards,

Armitha.

[Wojciech Wardaszko _HeroCoders_]

Hi @Armitha Reddy Toorpu Ceema 

I need to tell you that JQL can only return issues and not worklogs, let alone specific worklogs in an aggregated format.

You will not find what you want this way. You may look into native Jira reporting (The only one I can think of is the Time tracking report in Jira Software projects, but it has very limited capabilities and will not do what you want it to do) or take a look at free timesheet apps in the marketplace.

Cheers!

[Sreenivasaraju P]

Hi @Armitha Reddy Toorpu Ceema ,

Are you looking for part of (15 days) time spent on one ticket? If yes, Jira doesn't this feature by default. you can try with any third party apps.