How to get issues with a worklog item that has time spent over 8h via JQL

[Raphael Hirsch]

Hi all,

I would like to create a filter with JQL that filters all issues that contain a worklog item with a time spent >8 h.

Thank you in advance for your help

[Rilwan Ahmed]

Hi @Raphael Hirsch ,

Welcome to the community. 

You can write JQL as project = XXX and timespent >= 8h.

Below link contains details about available advance search JQL and examples. 

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-939938733.html

Please accept the answer if it helps you. 

[Raphael Hirsch]

Hi @Rilwan Ahmed

thank you for your fast answer.

I have already tried this query but it only gives me the issues with a total time spent >8h.

I want to have all issues that contain one or more worklog entries with more than 8h time spent in a single worklog entry.