I am trying to get the data under specific reporting mechanism, Like There is Manager->Engineering Leaders-> Engineers (Users). I want to get data of issues where assignees reporting hierarchy is aligned to specific users. I want to pull engineering leader wise data for specific leader. Is there any APIS exist for this scenario ?
Sam Ray (CXO) -> 15 Engineering leaders -> Engineers working among leaders
I want to pull issues where issue assignee hierarchy is belongs to one of the engineering leader
Hello @Akash Gunjal
Welcome to the Atlassian community.
Can you clarify if you are using the Jira Cloud (software-as-a-service) product or the self-hosted Server/Data Center product? If you click the Help button in Jira (near your avatar in the upper right corner) and select About Jira, what do you see in the pop up for a version number?
You mention the Team API in you summary. Have you defined Teams in you environment and assigned the engineers and leaders to the Teams? Are you then setting the Team field for each issue?
Do you have user groups defined where you have assigned all the engineers under a specific leader to a group?
Are you using the Assets feature where you have a record for each engineer that includes an attribute that identifies their leader?
Without a set up like one of the above there is nothing native in Jira that will enable you to get all the issues assigned to engineers under a specific leader by specifying the leader in the query. You have to have some feature already in place that establishes the relationship between each engineer and a leader, like a Team, a user group, or Asset objects.
Otherwise all you can do is manually construct a query such as
assignee in (engineer1, engineer2, engineer3)
...manually supplying the list of engineers under a specific leader.
Hello @Trudy Claspill , Thanks for your response. I am using Jira Cloud (SAAS). I am Not tagging any teams or leaders to issues in Jira.
It is like if I hover on assignee profile its redirecting me to Teams page where I can see reporting line.
Now as shown on above Image I want to get all issues where assignees are reporting to Rajnish. Under Rajnish there are 15 leaders are working and below that there are engineers who are working on Individual Jira issues. I want to pull data which can show all data engineering leader wise to Rajnish.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As I said if you are not adding a Team or User Group to each issue, where that Team or Group contains the engineers under a particular Leader, there is not a native JQL function to get what you want.
This document details how to create Teams.
https://support.atlassian.com/platform-experiences/docs/start-an-atlassian-team/
After Teams have been created, you then need to ensure that the Team field is added to the field configurations and screens for the work item types in all the Spaces from which you want to get data.
You will then have to set the value of the Team field in each work item.
Then you can use the JQL described by @Rik de Valk _Brainboss_ to create a query to retrieve the work items for one team at a time, or modify it to retrieve work items for all Teams thus:
Team is not empty
Or you could use:
Team in (comma separated list of Teams)
If you sort the output by the Team field you will be able to review the results and see the issues for each Team/leader.
Note that Jira does not automatically synchronize or set the Team field based on the value in the Assignee field. In fact that is very challenging to do, because a given Assignee can belong to more than one Team. So the value will need to be managed manually, or you would need to devise a custom solution for figuring which Team to select based on the Assignee.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Akash Gunjal ,
If you have organised all engineers into Teams you can use the JQL
assignee in membersOf("id:<teamId>")
in an API call to search for issues using the /rest/api/3/search/jql endpoint.
Alternatively, if you have organised in Groups, then you can use the same JQL, but by providing the Group
assignee in membersOf("Group")
Hope that helps.
Have a nice day!
Rik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Rik de Valk _Brainboss_ , as of now no I mean I have not created any specific team or related to leaders. Can you help me understanding how we can create group in Atlassian Teams?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Akash Gunjal
Is this about Jira Server or Jira Cloud?
Also we need more context what you wanna achieve.
Best,
Arkadiusz 🤠
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello @Arkadiusz Wroblewski , Thanks for your response can you please check first comment response I am trying to achieve that
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I checked your response, but @Trudy Claspill is already helping you very thoroughly. Providing similar solutions would likely only be more confusing. You're in good hands
Best,
Arkadiusz 🤠
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.