topic mapservice layer with definition query fails to execute query on rest site in ArcGIS REST APIs and Services Questions https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79767#M369 <HTML><HEAD></HEAD><BODY><P>I am using ArcGIS 10.3.1 to create and publish mapservices.&nbsp; I have an Oracle SDE layer with the following definition query: IS_DISPLAYED = 1 ORDER BY ISSUED_DATE ASC.&nbsp; The expression is successfully verified and displays the correct data in the mxd.&nbsp; 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."&nbsp; When I remove the definition query from the layer and re-publish the service, the query works just fine from the REST site.&nbsp; Is ArcGIS for Server unable to process this type of definition query through the mapservice?&nbsp; Is there a different definition query I should use instead to get the same results?</P></BODY></HTML> Sat, 24 Sep 2016 00:05:15 GMT BethannMcVicker 2016-09-24T00:05:15Z mapservice layer with definition query fails to execute query on rest site https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79767#M369 <HTML><HEAD></HEAD><BODY><P>I am using ArcGIS 10.3.1 to create and publish mapservices.&nbsp; I have an Oracle SDE layer with the following definition query: IS_DISPLAYED = 1 ORDER BY ISSUED_DATE ASC.&nbsp; The expression is successfully verified and displays the correct data in the mxd.&nbsp; 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."&nbsp; When I remove the definition query from the layer and re-publish the service, the query works just fine from the REST site.&nbsp; Is ArcGIS for Server unable to process this type of definition query through the mapservice?&nbsp; Is there a different definition query I should use instead to get the same results?</P></BODY></HTML> Sat, 24 Sep 2016 00:05:15 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79767#M369 BethannMcVicker 2016-09-24T00:05:15Z Re: mapservice layer with definition query fails to execute query on rest site https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79768#M370 <HTML><HEAD></HEAD><BODY><P>Bethann,</P><P></P><P>Exert for the ArcGIS Desktop help:</P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P>Building a query expression</P><DIV><DIV class=""><P>Because you are selecting columns as a whole, you cannot restrict the SELECT to return only some of the columns in the corresponding table because the SELECT * syntax is hard-coded. For this reason, keywords, such as DISTINCT, ORDER BY, and GROUP BY, cannot be used in an SQL query in ArcGIS except when using subqueries. See <A _jive_internal="true" class="" href="https://community.esri.com/thread/00s500000033000000.htm">SQL reference for query expressions used in ArcGIS</A> for information on subqueries.</P></DIV></DIV></BLOCKQUOTE></BODY></HTML> Sat, 24 Sep 2016 22:03:45 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79768#M370 RobertScheitlin__GISP 2016-09-24T22:03:45Z Re: mapservice layer with definition query fails to execute query on rest site https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79769#M371 <HTML><HEAD></HEAD><BODY><P>Thanks for the info.&nbsp; Do you know of a standardized query alternative for the query i'm using?&nbsp; I looked at the article but didn't see anything that could be substituted for ORDER BY.&nbsp; If not, I may try disabling standardized queries on my AGS to see if that fixes the problem.</P></BODY></HTML> Mon, 26 Sep 2016 19:23:22 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79769#M371 BethannMcVicker 2016-09-26T19:23:22Z Re: mapservice layer with definition query fails to execute query on rest site https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79770#M372 <HTML><HEAD></HEAD><BODY><P>Bethann,</P><P></P><P>&nbsp; &nbsp;The work of sorting the results is to be done my the client code that consumes the REST endpoint of the Map Service. For example if using the JS API the Query Class has a&nbsp;orderByFields property that can be set.</P></BODY></HTML> Mon, 26 Sep 2016 19:31:01 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79770#M372 RobertScheitlin__GISP 2016-09-26T19:31:01Z Re: mapservice layer with definition query fails to execute query on rest site https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79771#M373 <HTML><HEAD></HEAD><BODY><P>Apart from expression Check for map services capabilities</P><P>is you have enabled query option on this service or not?</P></BODY></HTML> Tue, 27 Sep 2016 10:21:18 GMT https://community.esri.com/t5/arcgis-rest-apis-and-services-questions/mapservice-layer-with-definition-query-fails-to/m-p/79771#M373 Anonymous User 2016-09-27T10:21:18Z