As per the original post.
How to get this information from data base tables How DB tables
PDMLinkProduct , WTOrganization ,WTGroup ,RolePrincipalMap, WTRolePrincipal , MembershiLink
I have information about this tables how this link with each other. i wanted to derive from PDMLink product as far as i have made this query but information is incomplete
SELECT
wtOrg.Name,
prod.namecontainerinfo,
--wtGroup.description,
wtGroup.name AS "TopeLevel",
wtGroupChild.name AS "SubLevel"
FROM
pdmlinkproduct prod
LEFT JOIN WTOrganization wtOrg ON prod.ida3organizationreference = wtOrg.ida2a2
LEFT JOIN WTGroup wtGroup ON prod.ida2a2 = wtGroup.ida3containerreference
LEFT JOIN MembershipLink memlink ON wtGroup.idA2A2 = memlink.idA3A5
LEFT JOIN WTGroup wtGroupChild ON memlink.idA3B5 = wtGroupChild.idA2A2
WHERE
prod.namecontainerinfo = 'Torch Products' AND wtGroupChild.name IS NOT NULL
ORDER BY wtGroup.name ASC;
