2

I'm trying to use the ArcGIS query feature, OrderByFields, but I've read that for that feature to work the feature layer must show "Supports Advanced Queries: true". The layer we are hosting says that "Supports Advanced Queries: false", but I can't find any documentation that says what is required for this property to be true.

We are currently using ArcMap 10.1 with shape files to publish our service definition files, and we are hosting the map services on ArcGIS server 10.1

5

https://developers.arcgis.com/rest/services-reference/enterprise/layer-table.htm

supportsAdvancedQueries would return false in the following scenarios:

The layer / table resides in a workspace other than an enterprise database or File Geodatabase.

The layer / table is joined with another layer / table from a different workspace.

We put our shape files into a File Geodatabase, and we were able to get Supports Advanced Queries to show true, but we are still having issues with using OrderByFields, but that is a different question.

1

The solution is use file or enterprise geodatabase, instead of shape file

In 2021 : ESRI's document link moved here

https://developers.arcgis.com/rest/services-reference/enterprise/layer-table.htm

supportsStatistics and supportsAdvancedQueries are dependent on the layer data source.

supportsStatistics would return false in the following scenarios:

The layer / table resides in a workspace other than an enterprise or file geodatabase. The layer / table has more than one join defined on it. The layer / table is joined with another layer / table from a different workspace. The layer / table has an outer join and where the workspace is earlier than 10.1, Geodatabase and application server connection is used. supportsAdvancedQueries would return false in the following scenarios:

The layer / table resides in a workspace other than an enterprise database or File Geodatabase. The layer / table is joined with another layer / table from a different workspace.

Support Distinct : false ? how to enable in map service ? https://community.esri.com/t5/arcgis-enterprise-questions/support-distinct-false-how-to-enable-in-map-service/td-p/679593

1
  • I updated my answer with the link you have here since my documentation link was dead. Thanks for keeping things up to date. – TJ Rockefeller Jun 25 at 19:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.