topic ArcGIS Server 10.2 MapService Query with returnDistinctValues returns 0 Records in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-10-2-mapservice-query-with/m-p/148096#M5907 <HTML><HEAD></HEAD><BODY><P>Hello, I have a map service that I am trying to return distinct values on using a query that utilizes greater than / less than operators. My first query appears as follows, and when executed, returns records.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P><A href="https://community.esri.com/legacyfs/online/60560_ags_query2.png"><IMG alt="ags_query2.png" class="image-2 jive-image" height="900" src="https://community.esri.com/legacyfs/online/60560_ags_query2.png" style="height: auto;" width="531" /></A></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Executing the same query with returnDistinctValues set to true returns 0 records.</P><P><A href="https://community.esri.com/legacyfs/online/60561_ags_query1.png"><IMG alt="ags_query1.png" class="image-3 jive-image" height="899" src="https://community.esri.com/legacyfs/online/60561_ags_query1.png" style="height: auto;" width="491" /></A></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Replacing the second part of the query with "1=1" also returns records</P><P><A href="https://community.esri.com/legacyfs/online/60562_ags_query3.png"><IMG alt="ags_query3.png" class="jive-image image-4" height="900" src="https://community.esri.com/legacyfs/online/60562_ags_query3.png" style="height: auto;" width="497" /></A></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>So the question is, what is it about the second part of my query that would cause the map service to return no records? It seems to be a problem with less than symbol but I have no way to confirm that.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>-James</P></BODY></HTML> Tue, 10 Feb 2015 14:21:29 GMT jamesmuir 2015-02-10T14:21:29Z ArcGIS Server 10.2 MapService Query with returnDistinctValues returns 0 Records https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-10-2-mapservice-query-with/m-p/148096#M5907 <HTML><HEAD></HEAD><BODY><P>Hello, I have a map service that I am trying to return distinct values on using a query that utilizes greater than / less than operators. My first query appears as follows, and when executed, returns records.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P><A href="https://community.esri.com/legacyfs/online/60560_ags_query2.png"><IMG alt="ags_query2.png" class="image-2 jive-image" height="900" src="https://community.esri.com/legacyfs/online/60560_ags_query2.png" style="height: auto;" width="531" /></A></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Executing the same query with returnDistinctValues set to true returns 0 records.</P><P><A href="https://community.esri.com/legacyfs/online/60561_ags_query1.png"><IMG alt="ags_query1.png" class="image-3 jive-image" height="899" src="https://community.esri.com/legacyfs/online/60561_ags_query1.png" style="height: auto;" width="491" /></A></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>Replacing the second part of the query with "1=1" also returns records</P><P><A href="https://community.esri.com/legacyfs/online/60562_ags_query3.png"><IMG alt="ags_query3.png" class="jive-image image-4" height="900" src="https://community.esri.com/legacyfs/online/60562_ags_query3.png" style="height: auto;" width="497" /></A></P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>So the question is, what is it about the second part of my query that would cause the map service to return no records? It seems to be a problem with less than symbol but I have no way to confirm that.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>-James</P></BODY></HTML> Tue, 10 Feb 2015 14:21:29 GMT https://community.esri.com/t5/arcgis-enterprise-questions/arcgis-server-10-2-mapservice-query-with/m-p/148096#M5907 jamesmuir 2015-02-10T14:21:29Z