Hi Patrick,
I think this will get you close... should be able to do similar in Query
Builder querying UIAccess joined to WTGroup...
select uiaccess.uicomponent,
uiaccess.category,
uiaccess.isrender,
windmin.wtgroup.NAME,
wtgroup.classnamekeycontainerreferen as Type,
exchangecontainer.namecontainerinfo as Site,
orgcontainer.namecontainerinfo as Org,
pdmlinkproduct.namecontainerinfo as Product,
wtlibrary.namecontainerinfo as Library,
project2.namecontainerinfo as Project,
uiaccess.displaystatus
from uiaccess
inner join wtgroup
on uiaccess.ida3a3 = wtgroup.ida2a2
left join exchangecontainer
on exchangecontainer.ida2a2 = wtgroup.IDA3containerreference
left join orgcontainer
on orgcontainer.ida2a2 = wtgroup.IDA3containerreference
left join pdmlinkproduct
on pdmlinkproduct.ida2a2 = wtgroup.IDA3containerreference
left join wtlibrary
on wtlibrary.ida2a2 = wtgroup.IDA3containerreference
left join project2
on project2.ida2a2 = wtgroup.IDA3containerreference
order by 1,2,3,4;
Thanks,
Eric
