{"id":3969,"date":"2021-07-09T21:31:43","date_gmt":"2021-07-09T13:31:43","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2021\/07\/09\/smart3d-0181\/"},"modified":"2026-08-20T18:19:50","modified_gmt":"2026-08-20T10:19:50","slug":"smart3d-0181","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/index.php\/2021\/07\/09\/smart3d-0181\/","title":{"rendered":"Smart3D\u4e2dSQL\u67e5\u8be2codelist\u503c"},"content":{"rendered":"
\n
x x x x x x x x x x x x\u00a0x<\/section>\n
\u5728\u4e4b\u524d\u7684\u6587\u7ae0S3D automation toolkit\u5de5\u5177\u4e4bCodelist value looku<\/a>p\u4e2d\uff0c\u6211\u4eec\u4ecb\u7ecd\u4e86\u4f7f\u7528\u5de5\u5177\u67e5\u8be2\u76f8\u5173codelist\u6570\u636e\u7684\u65b9\u5f0f\u3002<\/section>\n
\u6b64\u5916\uff0c\u8fd8\u53ef\u4ee5\u5728Smart3D\u4e2d\u67e5\u770b\u5bfc\u5165\u7684\u76f8\u5173catalog data<\/a>\u4e2d\u76f4\u63a5\u67e5\u770b\u76f8\u5173\u6570\u636e\u8868\u3002<\/section>\n

<\/p>\n

\u672c\u6587\u4e3b\u8981\u4ecb\u7ecd\u5728\u6570\u636e\u5e93\u4e2d\u76f4\u63a5\u67e5\u8be2\u76f8\u5173\u6570\u636e\uff1a<\/p>\n

\u9996\u5148\u6ce8\u610f\uff1aquery from catalog schema<\/span>\uff1a<\/p>\n

\u4e0b\u9762\u4e3a\u4ee5end preparation\u6570\u636e\u4e3a\u4f8b\u7684\u76f8\u5173\u67e5\u8be2\uff1a<\/p>\n

x x x x x x x x x x x x\u00a0x<\/p>\n

select AAA.ShortStringValue,AAA.LongStringValue,AAA.ValueID,AA.ShortStringValue,AA.LongStringValue,AA.ValueID,A.ShortStringValue,A.LongStringValue,A.ValueID\u00a0<\/p>\n

from iJCodeListValue as A<\/p>\n

join JTable_Has_JValues as B on A.oid = B.oidDst<\/p>\n

join IJCodeListTable as C on C.oid = B.oidOrg<\/p>\n

join IJCodeListValue as AA on A.ParentValueID = AA.ValueID<\/p>\n

join JTable_Has_JValues as BB on AA.oid = BB.oidDst<\/p>\n

join IJCodeListTable as CC on CC.oid = BB.oidOrg<\/p>\n

join IJCodeListValue as AAA on AA.ParentValueID = AAA.ValueID<\/p>\n

join JTable_Has_JValues as BBB on AAA.oid = BBB.oidDst<\/p>\n

join IJCodeListTable as CCC on CCC.oid = BBB.oidOrg<\/p>\n

where C.oid in<\/p>\n

(select oid from IJNamedObject where Name =’EndPreparation’)<\/p>\n

and<\/p>\n

CC.oid in<\/p>\n

(select oid from IJNamedObject where Name =’TerminationSubClass’)<\/p>\n

and<\/p>\n

CCC.oid in<\/p>\n

(select oid from IJNamedObject where Name =’TerminationClass’)<\/p>\n

order by AAA.ValueID, AA.ValueID,A.ValueID<\/p>\n

x x x x x x x x x x x x\u00a0x<\/p>\n

<\/p>\n

x x x x x x x x x x x x\u00a0x<\/p>\n

x x x x x x x x x x x x\u00a0x<\/p>\n

\u76f8\u5173\u9605\u8bfb\uff1a<\/p>\n

\u5173\u4e8eSmart3D\u4e2dcodelist\u957f\u77ed\u63cf\u8ff0\u76f8\u540c\u5f71\u54cd\u7684\u8bf4\u660e<\/a><\/p>\n

Smart3D catalog\u4e2d\u8c03\u6574view<\/a><\/p>\n

<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

x x x x x x x x x x x x\u00a0x \u5728\u4e4b\u524d\u7684\u6587\u7ae0S3D automation toolkit\u5de5 […]<\/p>\n","protected":false},"author":1,"featured_media":3967,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[9,18],"tags":[],"class_list":["post-3969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-smart3d","category-18"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/3969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/comments?post=3969"}],"version-history":[{"count":3,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/3969\/revisions"}],"predecessor-version":[{"id":7867,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/3969\/revisions\/7867"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media\/3967"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media?parent=3969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/categories?post=3969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/tags?post=3969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}