I am using ArcGIS 10.3.1 to create and publish mapservices. I have an Oracle SDE layer with the following definition query: IS_DISPLAYED = 1 ORDER BY ISSUED_DATE ASC. The expression is successfully verified and displays the correct data in the mxd. When I publish the mapservice containing this layer as a service, and try to do a query operation from the REST site on this layer, I get the following error: "Failed to execute query." When I remove the definition query from the layer and re-publish the service, the query works just fine from the REST site. Is ArcGIS for Server unable to process this type of definition query through the mapservice? Is there a different definition query I should use instead to get the same results?
... View more