How to get Team Members and Role information from Container

[adev]

Hello ,

I am working on the sql script where I will need to get the product team members and role information there is any way we can do that

[doehr]

It will likely be through a Query. Could you be a bit more specific on where exactly you are trying to get this information from? Is it for a system-wide report to get all users and their context team roles, or for the member list on a change object (change request, change notice etc), or something else?

[adev]

Hello Daryl,

I am trying to compare the users and there role with different products some of them are old products and some of them are new and I need to get the information which Product consist the Role and Members

[BineshKumar1 · Accepted solution]

If you looking for Context Team for products, this is what I used long back. This might require some tuning and optimization.

SELECT DISTINCT 
pd.namecontainerinfo,
grp.name,
member.name  
FROM 
(SELECT grp.name,grp.idA2A2,grp.idA3containerReference FROM WTGroup grp UNION ALL
SELECT grp.name,grp.idA2A2,grp.idA3containerReference FROM WTOrganization grp) grp,
PDMLinkProduct pd,
(SELECT member.idA2A2,member.name FROM WTGroup member UNION ALL
SELECT member.idA2A2,member.name FROM WTRolePrincipal member UNION ALL 
SELECT member.idA2A2,member.name FROM WTUser member) member,
MembershipLink mlink WHERE ((grp.name not like '%_ORG%') AND (grp.name not like '%roleGro%') AND (grp.name not like '%teamMem%')) AND
((mlink.idA3A5 = grp.idA2A2) AND 
(mlink.idA3B5 = member.idA2A2) 
AND (grp.idA3containerReference = pd.idA2A2))
GROUP BY pd.namecontainerinfo,grp.name,member.name 
ORDER BY pd.namecontainerinfo

Thank you,

Binesh Kumar

Medtronic - MITG

[adev]

Thank you so much Binesh for helping

[rupeshgote]

Hi All,

My requirement is quite similar. i want to get specific role from container. I am searching for java API.

Thanks.