Is it possible to exclude issues with a certain Component from a timesheet report?

I am experimenting with issues that have a component named "Roadmap". These issues exist in multiple JIRA projects. I would like to exclude these issues from my timesheet, but if I use a filter with the JQL "component != Roadmap" in my timesheet, the gadget takes forever to render (presumably because the filter returns hundreds of thousands of issues). Is there an alternative way that I can go about accomplishing this? Thank you!

3 answers

1 accepted

This widget could not be displayed.

Andriy, thank you for your response! I was confusing myself with how I was checking the components. The following JQL seems to return all of the issues that I expect: "worklogAuthor = currentUser() AND (component != Roadmap OR component is EMPTY)"

Thanks again, and have a good day!

Great, glad it works!

This widget could not be displayed.

Update: I was able to get the filter to (mostly) work by changing the JQL to "worklogAuthor = currentUser() AND component != Roadmap". The only problem that remains is there are certain issues that I have logged work to that are still not being returned by that filter. Perhaps I am misunderstanding how worklogAuthor is used. Does "worklogAuthor = currentUser()" only return issue for which the current user is the only user to have ever logged work?

This widget could not be displayed.

worklogAuthor should return all issues you've ever logged work on, also even other users have logged work on it. May be you can try worklogAuthor alone and see if component makes some issue disappear. Additionally you may use worklogDate clause, if you'd like to include all users worked issues, or limit result to issues recently worked on. Sorry I can't imagine better way than this.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

513 views 3 18
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you