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; } } }

Need to filter for for certain period logged hours for certain team members for certain project

Arevik Hakobyan

Hi Community,

I am facing issues with JQL filter:

I need to see logged hours for certain period of time (Sprint) for certain team members for certain project.

The filter I set up, brings the members and project and logged hours, but not for last 30 days but for all of the time.

I tried to put the filter by sprint but it doesnt work, as I need to see the logged hours for the project for the team members were done during the sprint.

Not sure what I am doing wrong here. Please advise

(worklogDate >= 2021-09-30 AND worklogDate < 2021-10-13 AND (worklogAuthor = 60fefeae8c15ca006ffdc496 OR worklogAuthor = 5dad6dfaeb076d0c302b4006 OR worklogAuthor = 60ff00c10b454a00689de0a7 OR worklogAuthor = 61111bf18c15ca006fc0e676 OR worklogAuthor = 60fef6bbfc68c100696d04b4)) AND project = "odoo Implementation"

Accepted answers

Jack Brickey

Let’s start by simplifying a bit…

worklogDate >= 2021-09-30 AND worklogDate < 2021-10-13 AND worklogAuthor in (60fefeae8c15ca006ffdc496, 5dad6dfaeb076d0c302b4006, 60ff00c10b454a00689de0a7, 61111bf18c15ca006fc0e676, 60fef6bbfc68c100696d04b4) AND project = "odoo Implementation"

however, not sure that solves your issue. It would be interesting to remove user component and assess…

project = "odoo Implementation" And worklogDate >= 2021-09-30 AND worklogDate < 2021-10-13

All comments

Jack Brickey

Let’s start by simplifying a bit…

however, not sure that solves your issue. It would be interesting to remove user component and assess…

project = "odoo Implementation" And worklogDate >= 2021-09-30 AND worklogDate < 2021-10-13

Trudy P Claspill

You can filter for issues that have time logged during a certain period, but there is no built in functionality that will then show you only those work log entries. Natively Jira can show you Time Spent, but that will be all the time logged on the issue, not just the time logged during the time period criteria you set in your filter.

If you want to see just the total time that was logged within your time period criteria you will have to use a third party app. We use this one

https://marketplace.atlassian.com/apps/1219004/worklogs-time-tracking-and-reports?hosting=cloud&tab=overview

Rahul_RVS

Hi @Arevik Hakobyan

This data is difficult to extract. If you would be interested in paid add-on, you can try out our app

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

The app provides the following features.

Worklogs & Time tracking Report :- Track time spent by resources with multiple filters / category / grouping features. Export to csv format is also available. You can filter based on worklogs time period as well.

Along with this there are multiple other features like Time in Status, Links Hierarchy, Epic Hierarchy etc which the app provides.

Worklogs Report - Additional Search.png

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

atl-gruland