{"id":9910,"date":"2026-08-21T15:50:12","date_gmt":"2026-08-21T07:50:12","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2026\/08\/21\/s3d%ef%bc%8cselect-by-filter\/"},"modified":"2026-08-21T15:50:12","modified_gmt":"2026-08-21T07:50:12","slug":"s3d%ef%bc%8cselect-by-filter","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/index.php\/2026\/08\/21\/s3d%ef%bc%8cselect-by-filter\/","title":{"rendered":"S3D\uff0cSelect By Filter"},"content":{"rendered":"<p>\u5173\u952e\u8bcd\uff1aPart\u5230Feature\uff0c Select By Filter \u95ee\u9898\u63cf\u8ff0\uff1a\u7fa4\u5185\u4f19\u4f34\u6709\u4e00\u4e2a\u9700\u6c42\uff0cPart\u4fe1\u606f\u4f5c\u4e3a\u8fc7\u6ee4\u6761\u4ef6\u9009\u4e2dF eature \u3002 \u89e3\u51b3\u601d\u8def\uff1a\u53ef\u4ee5\u5c1d\u8bd5\u4f7f\u7528\u5185\u7f6e\u7684Select By Filter\u529f\u80fd\u914d\u5408SQL-Filter\u5b9e\u73b0\u3002 select j1.Oid from JRtePipePathFeat j1 &#8211;j1-\u662fFetrue&#8211;\u63d0\u4f9b\u7b5b\u9009 inner join XPathGeneratedParts x1 on j1.Oid = x1.OidOrigin inner join XPartOccToMaterialControlData x2 on x2.OidOrigin = x1.OidDestination &#8211;j2-\u662fPCMD&#8211;\u63d0\u4f9b\u7b5b\u9009 inner join JGenericMaterialControlData j2 on x2.OidDestination = j2.Oid inner join XmadeFrom x3 on x3.OidOrigin = x1.OidDestination &#8211;J3-\u662fpart\u8868-\u63d0\u4f9b\u7b5b\u9009 inner join JDPipeComponent j3 on x3.OidDestination = j3.Oid &#8211;Where\u5173\u8054\u53e3\u5f84-\u53ef\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u5229\u7528J1,J2,J3\u8fdb\u884c\u7b5b\u9009 where j2.ShortMaterialDescription = &#039;PCMD-ShortMaterialDescription&#039; and j1.NPD = 6<\/p>\n<p><video controls preload=\"metadata\" style=\"width:100%;max-width:860px;border-radius:8px\" src=\"https:\/\/www.pipingpig.com\/wp-content\/uploads\/2026\/08\/ersrc_v\/45_S3D\uff0cSelect%20By%20Filter.mp4\"><\/video><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5173\u952e\u8bcd\uff1aPart\u5230Feature\uff0c Select By Filter \u95ee\u9898\u63cf\u8ff0\uff1a\u7fa4\u5185\u4f19\u4f34\u6709\u4e00\u4e2a\u9700\u6c42\uff0cPart\u4fe1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9909,"comment_status":"open","ping_status":"","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":[28],"tags":[],"class_list":["post-9910","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/9910","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=9910"}],"version-history":[{"count":0,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/9910\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media\/9909"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media?parent=9910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/categories?post=9910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/tags?post=9910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}