S3D，Select By Filter

关键词：Part到Feature， Select By Filter 问题描述：群内伙伴有一个需求，Part信息作为过滤条件选中F eature 。 解决思路：可以尝试使用内置的Select By Filter功能配合SQL-Filter实现。 select j1.Oid from JRtePipePathFeat j1 –j1-是Fetrue–提供筛选 inner join XPathGeneratedParts x1 on j1.Oid = x1.OidOrigin inner join XPartOccToMaterialControlData x2 on x2.OidOrigin = x1.OidDestination –j2-是PCMD–提供筛选 inner join JGenericMaterialControlData j2 on x2.OidDestination = j2.Oid inner join XmadeFrom x3 on x3.OidOrigin = x1.OidDestination –J3-是part表-提供筛选 inner join JDPipeComponent j3 on x3.OidDestination = j3.Oid –Where关联口径-可根据实际情况利用J1,J2,J3进行筛选 where j2.ShortMaterialDescription = 'PCMD-ShortMaterialDescription' and j1.NPD = 6