Hi, I'm using ArcGIS Server 10.6.1. published a map service with Dynamic Layer supported, layer source is from a SDE feature class. My question is, does the REST API support using subquery in Layer Definitions of the Export operation? seems it works fine with normal where clause like ID in (1,2,3,4), but when I tried insert a subquery to another SDE feature class (in the same SDE databased, owned by the same database user), it will returned with 'Invalid 'layerDefs' is specified'. The layer definition is like below, and select from the subquery works fine in ArcMap. Thanks.
Layer Definitions: { "0" : "OBJECTID NOT IN (Select OBJECTID from TEST.gis.anotherFeatureClass)"}
