Smart3D中SQL查询codelist值

本文主要介绍在数据库中直接查询相关数据：

首先注意：query from catalog schema：

下面为以end preparation数据为例的相关查询：

x x x x x x x x x x x x x

select AAA.ShortStringValue,AAA.LongStringValue,AAA.ValueID,AA.ShortStringValue,AA.LongStringValue,AA.ValueID,A.ShortStringValue,A.LongStringValue,A.ValueID 

from iJCodeListValue as A

join JTable_Has_JValues as B on A.oid = B.oidDst

join IJCodeListTable as C on C.oid = B.oidOrg

join IJCodeListValue as AA on A.ParentValueID = AA.ValueID

join JTable_Has_JValues as BB on AA.oid = BB.oidDst

join IJCodeListTable as CC on CC.oid = BB.oidOrg

join IJCodeListValue as AAA on AA.ParentValueID = AAA.ValueID

join JTable_Has_JValues as BBB on AAA.oid = BBB.oidDst

join IJCodeListTable as CCC on CCC.oid = BBB.oidOrg

where C.oid in

(select oid from IJNamedObject where Name =’EndPreparation’)

and

CC.oid in

(select oid from IJNamedObject where Name =’TerminationSubClass’)

and

CCC.oid in

(select oid from IJNamedObject where Name =’TerminationClass’)

order by AAA.ValueID, AA.ValueID,A.ValueID

x x x x x x x x x x x x x

x x x x x x x x x x x x x

x x x x x x x x x x x x x

相关阅读：

关于Smart3D中codelist长短描述相同影响的说明

Smart3D catalog中调整view