cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Actions for Roles Query

pwilliams-3
11-Garnet

Actions for Roles Query

10.1 M040

Does 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]

2 REPLIES 2

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




Here's the start of it using query builder...
If anyone fully builds it out, please share.

[cid:image003.png@01CF48CE.97AF88C0]

[cid:image004.png@01CF48CE.97AF88C0]
Top Tags