Windchill SQl篇之 软属性相关

-- 相关表
-- LWCTypeDefinition 类型定义表/ WTTypeDefinition/ WTTypeDefinitionMaster
-- 类型软属性表：LWCIBAAttDefinition
-- 类型主属性：LWCHARDATTDEFINITION
-- 国际化定义：LWCLocalizablePropertyValue

/*
 * 查指定软属性使用到的类型.
 * */ 
SELECT DISTINCT l.NAME /*类型名称*/,l1.VALUE /*属性名称（国际化显示的默认值）*/  FROM LWCIBAAttDefinition a,
STRINGDEFINITION s  ,
LWCTYPEDEFINITION l ,
LWCLocalizablePropertyValue l1
WHERE a.IDA3A7 = s.IDA2A2
AND a.IDA3A5 = l.IDA2A2 
AND s.NAME = 'xxx'  -- 属性内部名称
AND l.IDA2A2  = l1.IDA3B4 

/*
查询指定基础属性使用到的类型。
*/
SELECT DISTINCT l.NAME ,l1.VALUE ,l1.ZH_CN  FROM LWCHARDATTDEFINITION a,LWCTYPEDEFINITION l,
LWCLocalizablePropertyValue l1
WHERE a.NAME = 'versionInfo.identifier.versionId' --属性内部名称
AND a.IDA3A5 = l.IDA2A2 
AND l.IDA2A2  = l1.IDA3B4 


/*
全局枚举类型的值
*/
SELECT b.VALUE ,b.ZH_CN ,a.NAME ,e.NAME ,g.VALUE ,g.ZH_CN ,h.NAME  FROM LWCMasterEnumerationDefinition a,
LWCLocalizablePropertyValue b,LWCPropertyDefinition c,LWCEnumerationEntryLink d,
LWCEnumerationEntry e,LWCLocalizablePropertyValue g,LWCPropertyDefinition h
WHERE a.NAME  = ''  -- 全局枚举内部值
AND a.IDA2A2  = b.IDA3C4 
AND b.IDA3C4 = b.IDA3B4 
AND c.IDA2A2  = b.IDA3A4 
AND c.NAME = 'displayName'  --显示名称
AND d.IDA3A4  = a.IDA2A2
AND d.IDA3B4 = e.IDA2A2 
AND e.IDA2A2  = g.IDA3B4 
AND g.IDA3A4 = h.IDA2A2 


/*
依据全局枚举项的中文查询  
*/
SELECT b.VALUE ,b.ZH_CN ,a.NAME ,e.NAME ,g.VALUE ,g.ZH_CN ,h.NAME  FROM LWCMasterEnumerationDefinition a,
LWCLocalizablePropertyValue b,LWCPropertyDefinition c,LWCEnumerationEntryLink d,
LWCEnumerationEntry e,LWCLocalizablePropertyValue g,LWCPropertyDefinition h
WHERE ( g.ZH_CN = 'xxx' OR g.VALUE = 'xxx')
AND a.IDA2A2  = b.IDA3C4 
AND b.IDA3C4 = b.IDA3B4 
AND c.IDA2A2  = b.IDA3A4 
AND c.NAME = 'displayName'
AND d.IDA3A4  = a.IDA2A2
AND d.IDA3B4 = e.IDA2A2 
AND e.IDA2A2  = g.IDA3B4 
AND g.IDA3A4 = h.IDA2A2 ;

/* 查软属性的显示名称*/
SELECT b.NAME ,l1.VALUE ,l1.ZH_CN  FROM LWCLocalizablePropertyValue l1 ,
LWCPropertyDefinition a,
 LWCIBAAttDefinition b
WHERE a.IDA2A2 = l1.IDA3A4
AND a.NAME = 'displayName'
AND L1.IDA3B4 = b.IDA2A2 
AND b.NAME = 'material_lifecycle_status'