Hi, I am having trouble implementing some functionality we have on our 9.3 and 10.0 servers with version 10.2 (all internal servers so cannot share URLs)I need to run a query against a feature class stored in Oracle (ArcSDE 9.3) with where clause that reads something like this (is generated from a mouse-click):sdo_nn(shape, mdsys.sdo_geometry(2001, 81989, mdsys.sdo_point_type(385878.8,247670.9,null),null,null), 'sdo_num_res=1', 1) = 'TRUE' AND sdo_within_distance(shape , mdsys.sdo_geometry(2001, 81989, mdsys.sdo_point_type(385878.8,247670.9, null), null, null),'distance=250 UNIT=M') = 'TRUE'
We use this to get features that are within certain distance from a user defined (clicked) point in our JavaScript app, it has been much faster than using Esri spatial filters.If I use this where clause in the HTML interface of query tasks in services directories, it works for the services published from ArcGIS Server 9.3 and 10.0, but for the service at 10.2 i get:code: 400, message: "Unable to complete operation."I would appreciate any help.Filip.