S3D-SQL查询RunLength

关键词： SQL， RunLength， XAlongLeg， CORERelationOrigin 问题描述： RunLength通常获得方式，是通过官方的A dditional- Label。本次分享重点关注如何在SQL中实现 RunLength的查询。 感兴趣的伙伴，敲到自己环境中，探索试一试。 –在MDB中查询 SELECT subquery.oidOrigin, MIN (subquery.ItemName) AS ItemName, SUM (subquery.Distance) AS TotalDistance FROM ( SELECT DISTINCT j1.ItemName, x1.oidOrigin, c1.oid, –两点求长 SQRT ( POWER (r1.EndLocationX – r1.StartLocationX, 2 ) + POWER (r1.EndLocationY – r1.StartLocationY, 2 ) + POWER (r1.EndLocationZ – r1.StartLocationZ, 2 ) ) * 1000 AS Distance –1000控制单位 FROM XPathSpecification x1 INNER JOIN CORERelationOrigin c1 ON x1.oidDestination = c1.oidTarget INNER JOIN ROUTEPathLeg r1 ON c1.oid = r1.oid INNER JOIN JNamedItem j1 ON j1.oid = x1.oidOrigin WHERE c1.RelationType = 'B075C7A3-9F26-11D1-BE28-08003651A403' –XAlongLeg AND x1.oidOrigin = '此处输入Run的Oid，如删除此行，则全局搜索' — 测试用Oid ) AS subquery GROUP BY subquery.oidOrigin;