Retrieving team members from Advanced Roadmaps

[Rick Olson]

Does anyone have JQL that would retrieve the team members for each shared team in Advanced Roadmaps along with the hours planned for the team member?

[Dave · Accepted solution]

Hi @Rick Olson,

I don't think that it's possible to achieve what you'd like through JQL at the moment, but I'm really interested in the use case that you're describing at the moment. We're doing a lot of research into how users want to manage and report on capacity at both the team and individual level so the insights you've shared in your comments are invaluable.

Ideally we'd like to be able to build features into Advanced Roadmaps that might support the sort of thing that you're looking to achieve, but due to the nature of plans you'd need to see all the individuals and work in the same plan ... so I'm wondering if this was why you were looking at this from a JQL angle? Or if that was simply because the features aren't available in Advanced Roadmaps yet?

It's really interesting that you have individuals split across teams. In practice does this mean that they split their time between each team evenly or can it vary from week-to-week / sprint-to-sprint (out of interest are you using Scrum or Kanban?)

Also, do you consider all individual as contributing equally? i.e. do they all do the same number of hours or would you want to adjust it for some individuals and / or plan for absences or secondments, etc?

Regards,

Dave

[Rick Olson]

We do have everyone in the same project and, by team a person's allocation isn't split evenly. Thus the concern for over/under allocation.

Another reason for trying to use JQL for the team members and their planned hours is to compare the planned hours to actual hours for the person, by team, to see if the allocation needs to be modified.

Yes, we would like to increase/decrease a person's allocation from sprint to sprint, especially for those people performing "infant care" shortly after a release where we don't want to plan their contribution to development as high.

[Ste Wright]

Hi @Rick Olson 

As far as I know, you can't reference the team members, or their hours planned, in JQL.

You couldn't return the team members or their hours as results either; JQL only searches for issues themselves. 

What is it you are specifically trying to achieve, as there might be an alternative?

Ste

[Rick Olson]

We have almost 200 people in a single Jira project for which we have those people allocated across a number of shared teams.

One of the challenges we have is that with each team member usually being split across teams that, sometimes, they are over allocated--meaning that they could be included as 25 weekly hours of capacity for Team A and 30 weekly hours for Team B. For our SoS meetings, we need to surface this over-allocation problem.

It can also be that some team members are not included on any shared team, or that their total weekly capacity isn't fully allocated across teams.

Thus, I'm trying to report the team member and their weekly hours of capacity for each shared team, and total those hours to know if a team member is over/under allocated.