Teamcenter 数据集相关的sql

--根据item_id查询数据集

select pi.pitem_id,pir.pitem_revision_id, pws.pobject_name,pws.pobject_type,ds.puid dataset_puid
from infodba.pdataset ds
inner join pimanrelation prel on prel.rsecondary_objectu =ds.puid
inner join infodba.pitemrevision pir on prel.rprimary_objectu = pir.puid
inner join infodba.pitem pi on pir.ritems_tagu =pi.puid
inner join infodba.pworkspaceobject pws1 on pir.puid = pws1.puid and pws1.pactive_seq !=0
inner join infodba.pworkspaceobject pws on pws.puid =ds.puid and pws.pactive_seq !=0
where pi.pitem_id ='BSC-000189' order by PITEM_REVISION_ID DESC;

--根据数据集puid查询  文件地址

select pv.pnode_name,pv.pwnt_path_name,'\'||pf.psd_path_name||'\'||pf.pfile_name,pf.poriginal_file_name --,pws.pobject_name,pws.pobject_type
from infodba.pimanfile pf
inner join infodba.pref_list_0 pl0 on pl0.pvalu_0 = pf.puid
inner join infodba.pdataset ds on pl0.puid = ds.puid and ds.puid = 'C6vVy0mMJejwLA'
--inner join infodba.pworkspaceobject pws on pws.puid =ds.puid and pws.pactive_seq !=0
inner join infodba.pimanvolume pv on pf.rvolume_tagu=pv.puid
where instr(pf.poriginal_file_name,'.qaf') >0 ;