One of the JIRA users has left the company and transition was not smooth. As a result, there are still components (across multiple projects) which have the user either as default assignee or component lead. I want to determine which are these components so that I can reassign. Is this possible via JQL?
This is not possible using JQL. JQL can only return issues, not components in it's result set. Here is a postgresql query which should help you get what you need:
select pname, cname, component.lead from component join project on (component.project = project.id) where lead = 'username';
Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...
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!
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
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot