How to generate report of team members involved in various projects?

Question

Hello, I have a front end team and they are involved in numerous projects. How do I generate report of the status of the team members?

I created a team and added all my team members but I was unable to fetch report for a particular project. I used the below JQL:

project = "ABC" and team = "Trial Team"

Then, I added the team members by going to Jira groups and used the below JQL:

project = "Development and Integration" and assignee IN membersOf("Trial Team")

Please let me know if the JQL used is correct. And, please let me what would be the JQL to know the status of my team for all the projects they are working on.

Trudy P Claspill · Answer

Doing a search based on the Team field will look for issues where that Team field in the issue has the value you specified. This is the same as searching based on the content of any other field.

With the Teams functionality you need to create a Team and then set the built-in Team field in each issue to indicate the Team that owns the issue.

Use of the Team field does not give you any functionality around finding issues associated directly with the members of the Team.

Also, currently the membersOf() function doesn't support Teams like it supports User Groups.

unknown · Answer

Yes. Why did team = "Trial Team" not work when I used that? Then what is the use of creating teams under "TEAM"?

Trudy P Claspill · Answer

project = "ABC" and team = "Trial Team"

User Groups cannot be used in the native Team field. If the above filter is using the native Team field then that will not provide the correct results.

project = "Development and Integration" and assignee IN membersOf("Trial Team")

That filter should provide you a list of the issues from the specified project where the issues are currently assigned to people who are members of the user group "Trial Team".

Is that not the information you want?

JQL is used to give you a list of issues. How would that tell you determine the status of the team members based on that information?