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
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.
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
