I am trying to create a filter spanning multiple jira projects. I want to use the "Project lead" value in the project settings as part of the query. How do you reference this field?
Thank you @Trudy Claspill This is good information but it doesn't quite get me there. It appears the function can only return the active or a specific user. I am looking for it t to reutnr multiple users for example. If I query for a projects, return the project lead of each one or sort the list bu project lead value. Any ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Filters are designed to retrieve issues, not Project information.
You can use Project level information to help select the projects from which issues will be retrieved, but that Project level information is not issue level information. I don't believe you can sort the issues based on the project lead nor include the project lead value in the filter output.
Let us clarify the problem you are trying to solve.
Are you trying to get a list of issues or a list of projects?
Do you want to limit the results based on Project Lead, or do you just want to use the Project Lead in the output?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Again, must appreciative of your time. Im learning a lot... Specifically, I want to get a a list of issues from a filter by project grouped by project lead. And, btw, use the filter in a Plan. Here is the scenario: I have about 30 jira projects that I want to track. I have 6 project leads, each leading a subset of projects (averages to about 5 projects per lead but not all leads have the same number of projects) I got it to where the filter returns me what I want but I want to sort or group these projects by project leads. My query looks similar to this: project IN (... list of specified projects...) AND issuetype IN (... list of specified issuetypes...) AND status IN (...list of specified statuses...) ORDER BY project DESC This filter does what I want it to do, except I want to sort the projects by my project leads. So each of my project leads' projects are together in the list. I can also accept having a separate query one for each of my leads. (Can I do that?) I tried inserting a AND projectsLeadByUser(name) into the filter but it errors.
Thoughts?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You won't be able to add the project leads to the ORDER BY clause of the filter. The ORDER BY clause can only use fields in the issues themselves. While Project is stored in the issue, Project Lead is not.
To use the projectsLeadByUser() function to limit the results to issues in the projects lead by the specified user you have to insert not the user's "name" but rather their cloud account id; i.e.
project in projectsLeadByUser(5edebb3cabcdef0ab529eba0)
Get the user's account id by
1. Going to the Teams menu option.
2. Search for the user.
3. Click on the user's tile to display the user's information.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.