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

1 vote
Answer accepted

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!

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?

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 Mar 13, 2019 in Marketplace Apps

Marketplace Spotlight: Marketing apps for Confluence to keep your teams working on the same page


247 views 0 6
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