Solved
How to get Team Members and Role information from Container
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
BineshKumar1Answer
2-Explorer
February 21, 2016
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