Most of feature layer published on Arcgis Server use one of following 3 type of source, source type matters. 

Before you publish feature layer to arcgis server, your data's source could be following 3 type:

 

 

1) ESRI file geodatabase as source

                      Arcgis REST API will supports Advanced Queries,  supports Statistics, supports Count Distinct, supports Distinct

                      This gives you most advanced query capability. 

                      Data geometry use Esri ST_Geometry as data type.

                      Try this sample below.

Click here open full screen in a new tab

 

 

2) Oracle  as source

         Arcgis REST API will supports Advanced Queries,  supports Statistics, supports Count Distinct, supports Distinct

         However,  outStatistics, are not supported. Statistics query is only working on feature classes with ST_GEOMETRY storage

         

     outStatistics return 'unable to complete operation'

          https://community.esri.com/t5/arcgis-enterprise-questions/outstatistics-return-unable-to-complete-operation/td-p/456011

         Oracle use Oracle's SDO_GEOMETRY  are not work with statistic query. Only ST_GEOMETRY works.  I have not test Microsoft SQL server, only if SQL server use ST_GEOMETRY, statistic query will work.

         This gives you a limited advanced query capability without statistic query. 

         In SQL statement, you can use 'disticnt', but not 'group by'.  Group-by is part of statistic query, distint is not.   

         This affect the behavior of MCS,  with 'distinct' in SQL,  user have to click each field value node to get total count of that, for example,   you click any field value 'xxxxxxx',    it becomes    xxxxxxx {~ total count ~}

         Otherwise, with 'group by',  it show all field value filtered total count at the beginning, for example, it show all field value as  xxxxxxx {~ total count ~} all the time. 

         Try this sample below. 

Click here open full screen in a new tab

 

 

3) shape file as source

                      Arcgis REST API will NOT supports Advanced Queries,  NOT supports Statistics, NOT supports Count Distinct, NOT supports Distinct

                      In SQL statement, 'distinct' and 'group by' are NOT supports, statistic query are NOT supports

                      Try this sample below.

Click here open full screen in a new tab

 

 

 

More on Los Angeles Arcgis server

Click here open full screen in a new tab

by

Please log in or register