Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Report

Shakila Hudda-Shaikh December 18, 2024

I am trying to run a report to identify which issues/tickets don't have any time logged against them at all.

I only know how to run a report where users haven't logged time 

Thanks

1 answer

3 votes
Walter Buggenhout
Community Champion
December 18, 2024

Hi @Shakila Hudda-Shaikh and welcome to the Community!

The following filter returns all issues without logged time in a project:

project = "Your Project" AND timespent is empty

Hope this helps!

Shakila Hudda-Shaikh December 19, 2024

Thank you 

Am trying to add multiple project rather than just one - Suggestions?

 

Nazarii Sobchuk _Grandia Solutions_
Atlassian Partner
December 19, 2024

Hi Shakila, you can use something like the following:

 

project in (ABC, XYZ) AND timespent is empty


where ABC, XYZ are your project keys. You can also use project names like “My company Project” inside of the parentheses.

 

Hope this helps

Shakila Hudda-Shaikh December 19, 2024

Thank you 

I need to brush up on my SQL in Jira :-)

 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events