Actions for Roles Query

Question

10.1 M040Does anyone know how to write a sql query or Query Builder report to produce the data for the below screenshot for a context?[cid:image001.jpg@01CF48DA.9587D050]Patrick Williams | Engineering Systems | c: 616.947.2110[cid:image002.jpg@01CF48DA.9587D050]

ericstarkman · Answer

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

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.