Smart 3D数据库中codelist数据查看方案

--Execute the following query on the CDB Schema.
select A.ParentValueID,A.ValueID,A.ShortStringValue,A.LongStringValue 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 IJNamedObject as iName on iName.oid =C.oid
join IJAdminInfo as Ad on Ad.oid = A.oid
where iName.Name='PressureRating' and Ad.IsDeleted = 0
order by A.ParentValueID