Use shape file as source when publish to Arcgis Server, Supports Advanced Queries: false
see this example:
How to set Supports Advanced Queries: true
see this example
Base on ESRI's document, Supports Advanced Queries would be false in the following scenarios:
1). The layer / table resides in a workspace other than an Enterprise Geodatabase or File Geodatabase.
2). The layer / table is joined with another layer / table from a different workspace.
If the source is a File geodatabase or Enterprise geodatabase, Supports Advanced Queries is set to be true automatically. You don't need to do any configure.
ESRI's document : 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:
supportsAdvancedQueries would return false in the following scenarios:
Support Distinct : false ? how to enable in map service ?