ST_Geometry functions applied to the Shape field in Select By Attributes return the error message, "Error 000358: Invalid expression" if the feature class is registered as traditional versioned.

Solution de contournement

• Place the expression in subquery. For example:

OBJECTID IN 

(SELECT 

  OBJECTID

FROM

  INFRASTR.ACTIVE_TRANSPORTATION

where

  sde.st_length(shape) > 400

)

• Use calculate geometry or calculate field to populate new fields with the values. Then, apply any further ST_Geometry functions on the fields instead of using the shape field.

Étapes pour reproduire