How to create a filter for project lead?

[Ingmar Flach]

Hello everyone,

I'm trying to create a filter based on the project lead dropdown in the project settings. in the filter settings I get the JQL autocomplete suggestion "Lead [Dropdown]". All further tryings to get a result with '=' or 'IS' created errors. 
I also tried this solution without positive result: 

Solved: How can I filter issues by project lead?

What is my mistake?

[Sergei Troshin]

Hello @Ingmar Flach and Welcome to Atlassian Community!

The fact is that filtering by Project Lead works only for the project field in JQL. If you are using another field (e.g., "Lead [Dropdown]"), it won't work.



Could you please provide your full JQL and clarify what you want to filter out?

[Kai Krause]

Hi and Welcome 

project in projectsLeadByUser(username) gives you all Issues where the username is the projectlead or  project in projectsLeadByUser() gives you all issues where the currentUser() ist the project lead. 

When you try to use a hardcoded username , be aware that with username ist not mean the username , but therefore the string reprensatation of the username. The user in the atlassian cloud is a  hash of letters and numbers.

If you select your avatar in the top right corner and click "profile", you will see this hash in the url in your browser., something like 

If you use this string instead instead of the real user name , you should get results.

BR
Kai

[Prachi Bolar]

Hello,

Welcome to community :) 

As per the documentation https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#projectsLeadByUser--:~:text=pendingBy(jsmith%2C%20skhan)-,projectsLeadByUser(),-Find%20work%20items

 you will be able to list all projects from a Project Lead by the following expression:

project in projectsLeadByUser() - will retrieve all issues from projects where you are the Project Lead.

project in projectsLeadByUser(userID) - By informing the User ID of a user in this function, it will retrieve all issues from projects where the person is a Project Lead. You can find the userID of each account by reviewing the last part of the URL from the ** user's profile on the user management page.

Additionally, we would like to make you aware that there's a Feature request for this topic:

• JRACLOUD-10673 - Ability to filter issues by project lead

Thank you,

Prachi