{"id":1138,"date":"2024-07-21T10:41:52","date_gmt":"2024-07-21T02:41:52","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2024\/07\/21\/smart3d-0570\/"},"modified":"2026-08-20T18:19:28","modified_gmt":"2026-08-20T10:19:28","slug":"smart3d-0570","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/index.php\/2024\/07\/21\/smart3d-0570\/","title":{"rendered":"Smart 3D\u4e2dSQL filter\u793a\u4f8b"},"content":{"rendered":"<div class=\"content\">\n<p style=\"text-align: center\"><span style=\"font-size: var(--articleFontsize);letter-spacing: 0.034em\">x x x x x x x x x x x x x x<\/span><\/p>\n<p>\u8fc7\u6ee4\u5f53\u524d\u9879\u76ee\u4e2d\u7684piperun\uff1a<\/p>\n<p>select oid from jrtePiperun<\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-imgfileid=\"100009861\" data-ratio=\"1.0768156424581006\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0000.png\" data-type=\"png\" data-w=\"716\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0000.png\" \/><\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-imgfileid=\"100009862\" data-ratio=\"0.5333333333333333\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0001.png\" data-type=\"png\" data-w=\"1080\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0001.png\" \/><\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p>\u540d\u5b57\u4e2d\u5305\u542b\u6307\u5b9a\u5185\u5bb9\u7684piperun\uff1a<\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p>select a.oid from JRtePipeRun a<\/p>\n<p>join JNamedItem b on b.oid=a.oid<\/p>\n<p>where b.ItemName like &#8216;%1C0031%&#8217;<\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-imgfileid=\"100009938\" data-ratio=\"1.0635359116022098\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0002.png\" data-type=\"png\" data-w=\"724\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0002.png\" \/><\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x x x x\u00a0<\/span><\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x x x x<\/span><\/span><\/p>\n<p style=\"text-align: center\">select by filter\u6d4b\u8bd5<\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img js_insertlocalimg\" data-imgfileid=\"100009939\" data-ratio=\"0.623725671918443\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0003.gif\" data-type=\"gif\" data-w=\"1079\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0003.gif\" \/><\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p>\u5982\u4e0a\uff0c\u53ef\u4ee5\u53d1\u73b0piperun\u5e76\u65e0\u5b9e\u4f53\uff0c\u4e0b\u9762\u6d4b\u8bd5\u52a0\u8f7dpiping parts\u6709\u5b9e\u4f53\u7684\u5bf9\u8c61\uff1a<\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p>select oid\u00a0 from JRtePipePart<\/p>\n<p>union<\/p>\n<p>select a.oid from JRteCompOccur a<\/p>\n<p>join JDPipeComponent b on a.oid =b.oid<\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img\" data-galleryid=\"\" data-imgfileid=\"100009940\" data-ratio=\"0.525\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0004.png\" data-type=\"png\" data-w=\"560\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0004.png\" \/><\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img js_insertlocalimg\" data-imgfileid=\"100009942\" data-ratio=\"0.623725671918443\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0005.gif\" data-type=\"gif\" data-w=\"1079\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0005.gif\" \/><\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p>\u52a0\u8f7d\u4eea\u8868\u4ef6\uff1a<\/p>\n<p>select oid from JRteInstrument<\/p>\n<p style=\"text-align: center\"><span style=\"letter-spacing: 0.578px;text-align: center\">x x x x x x x x x x x x x x<\/span><\/p>\n<p style=\"text-align: center\"><img decoding=\"async\" class=\"rich_pages wxw-img js_insertlocalimg\" data-imgfileid=\"100009943\" data-ratio=\"0.623725671918443\" data-s=\"300,640\" data-src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0006.gif\" data-type=\"gif\" data-w=\"1079\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/0570_img_0006.gif\" \/><\/p>\n<p><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>x x x x x x x x x x x x x x \u8fc7\u6ee4\u5f53\u524d\u9879\u76ee\u4e2d\u7684piperun\uff1a select oid [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1131,"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,10],"tags":[],"class_list":["post-1138","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-smart3d","category-10"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/1138","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=1138"}],"version-history":[{"count":4,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/1138\/revisions"}],"predecessor-version":[{"id":7481,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/1138\/revisions\/7481"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media\/1131"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media?parent=1138"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/categories?post=1138"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/tags?post=1138"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}