I saw in ArcGIS PRO documentation that it's possible to use SQL subqueries in definition queries.
I would like to know if it is possible to use spatial function like st_intersects or st_within to dynamically filter a layer or create label classes.
I tried this subquery in definition query but when I check this request it's OK but I can't apply it :
OBJECTID IN (SELECT TABLE2.OBJECTID FROM SCHEMA.TABLE1, SCHEMA.TABLE2 WHERE SCHEMA.TABLE1.NAME= 'xxxx' AND SDE.ST_INTERSECTS(SCHEMA.TABLE1.SHAPE, SCHEMA.TABLE2.SHAPE) = 1 ;
I work with ArcGIS PRO 2.6.2, maybe it's possible in newest version.