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?
Hello Manju,
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';
Cheers,
Boris
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.