You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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.
Disclaimer : I am part of the app development team
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.
Do you want the worklog for 15 days? If yes, you can try worklogDate option in the query.
project = "project name" AND worklogAuthor = "whose work log you want "AND worklogDate >= "2023/09/01" AND worklogDate <= "2023/09/15"
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,
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.