How to turn on Advanced Queries

Question

                   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

https://gis.la-quinta.org/arcgis/rest/services/GoGov/goGov2230/MapServer/0

 

 

                    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:

• 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