topic Re: How to Query for Distinct Values? in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/how-to-query-for-distinct-values/m-p/324613#M12486 <HTML><HEAD></HEAD><BODY><SPAN>it should be supported in 10.1 SP1 only for layer/table whose supportsAdvancedQueries property returns true.</SPAN></BODY></HTML> Thu, 13 Sep 2012 21:05:15 GMT TanuHoque 2012-09-13T21:05:15Z How to Query for Distinct Values? https://community.esri.com/t5/arcgis-enterprise-questions/how-to-query-for-distinct-values/m-p/324612#M12485 <HTML><HEAD></HEAD><BODY><SPAN>I have a mapservice published to ArcGIS Server 10.1. On the </SPAN><BR /><BR /><SPAN>myserver:6080/arcgis/rest/services/..../MapServer</SPAN><BR /><BR /><SPAN>I would like to specify a Query where I can get all the unique values for a specific field (i.e. "myfield")</SPAN><BR /><BR /><SPAN>An example of the values "myfield" contains is:</SPAN><BR /><SPAN>A</SPAN><BR /><SPAN>A</SPAN><BR /><SPAN>B</SPAN><BR /><SPAN>B</SPAN><BR /><SPAN>C</SPAN><BR /><SPAN>C</SPAN><BR /><SPAN>D</SPAN><BR /><SPAN>D</SPAN><BR /><BR /><SPAN>What I want the query to return is:</SPAN><BR /><SPAN>A</SPAN><BR /><SPAN>B</SPAN><BR /><SPAN>C</SPAN><BR /><SPAN>D</SPAN><BR /><BR /><SPAN>What parameters should I specify to get DISTINCT values? I tried sticking DISTINCT in the "Where:" box, but it did not work.</SPAN></BODY></HTML> Thu, 13 Sep 2012 20:07:12 GMT https://community.esri.com/t5/arcgis-enterprise-questions/how-to-query-for-distinct-values/m-p/324612#M12485 MikeRobinson1 2012-09-13T20:07:12Z Re: How to Query for Distinct Values? https://community.esri.com/t5/arcgis-enterprise-questions/how-to-query-for-distinct-values/m-p/324613#M12486 <HTML><HEAD></HEAD><BODY><SPAN>it should be supported in 10.1 SP1 only for layer/table whose supportsAdvancedQueries property returns true.</SPAN></BODY></HTML> Thu, 13 Sep 2012 21:05:15 GMT https://community.esri.com/t5/arcgis-enterprise-questions/how-to-query-for-distinct-values/m-p/324613#M12486 TanuHoque 2012-09-13T21:05:15Z