https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/querytask-distinct-geometry-query/m-p/1034560#M71987 <P>Hi, in my application, I'm using the ArcGIS for JavaScript, version 3.35.&nbsp;</P><P>In JavaScript, I've created a <STRONG>QueryTask</STRONG> to find all of the features in a layer which are contained in the specified geometry.&nbsp; This will often exceed 1,000 features as indicated in the exceededTransferLimit property of the resultant FeatureSet.&nbsp; I have a loop in JavaScript, which loops over the results and adds the unique values to an array.</P><P>Is there a way to set the <STRONG>returnDistinctValues&nbsp;</STRONG>property of the Query while also providing the <STRONG>geometry</STRONG>?&nbsp;</P><P>When we set returnDistinctValues to true, the query does not return any features.&nbsp; If using Distinct is possible, we could do the processing on the server instead of on the client.&nbsp; Note: The data is in a file geodatabase.</P><LI-CODE lang="javascript">let myArray = []; const queryTask = new QueryTask(url); const query = new Query(); query.geometry = geometry; query.spatialRelationship = Query.SPATIAL_REL_CONTAINS; query.outFields = ["SOMEVALUE"]; //query.returnDistinctValues = true; // this returns no results when true query.distance = 10; query.units = "feet"; queryTask.execute(query, function(featureSet) { $.each(featureSet.features, function(index, feature) { const someValue = feature.attributes["SOMEVALUE"]; if (someValue &amp;&amp; parseInt(someValue) &gt;= 0) { if (myArray.indexOf(someValue) === -1) { myArray.push(someValue); } } }); resolve(myArray)); }, function(err) { reject(err); });</LI-CODE><P>The FeatureLayer that we're querying has the supportsAdvancedQueries set to true.&nbsp;&nbsp;ESRI’s documentation says Distinct is supported if the layer has the supportsAdvancedQueries option set to true.</P><P class="xmsonormal"><A href="https://developers.arcgis.com/javascript/3/jsapi/query-amd.html#returndistinctvalues" target="_blank">https://developers.arcgis.com/javascript/3/jsapi/query-amd.html#returndistinctvalues</A></P><P>Thanks for any insight or assistance.</P> Tue, 09 Mar 2021 17:38:05 GMT AndyWhitaker1 2021-03-09T17:38:05Z https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/querytask-distinct-geometry-query/m-p/1034560#M71987 <P>Hi, in my application, I'm using the ArcGIS for JavaScript, version 3.35.&nbsp;</P><P>In JavaScript, I've created a <STRONG>QueryTask</STRONG> to find all of the features in a layer which are contained in the specified geometry.&nbsp; This will often exceed 1,000 features as indicated in the exceededTransferLimit property of the resultant FeatureSet.&nbsp; I have a loop in JavaScript, which loops over the results and adds the unique values to an array.</P><P>Is there a way to set the <STRONG>returnDistinctValues&nbsp;</STRONG>property of the Query while also providing the <STRONG>geometry</STRONG>?&nbsp;</P><P>When we set returnDistinctValues to true, the query does not return any features.&nbsp; If using Distinct is possible, we could do the processing on the server instead of on the client.&nbsp; Note: The data is in a file geodatabase.</P><LI-CODE lang="javascript">let myArray = []; const queryTask = new QueryTask(url); const query = new Query(); query.geometry = geometry; query.spatialRelationship = Query.SPATIAL_REL_CONTAINS; query.outFields = ["SOMEVALUE"]; //query.returnDistinctValues = true; // this returns no results when true query.distance = 10; query.units = "feet"; queryTask.execute(query, function(featureSet) { $.each(featureSet.features, function(index, feature) { const someValue = feature.attributes["SOMEVALUE"]; if (someValue &amp;&amp; parseInt(someValue) &gt;= 0) { if (myArray.indexOf(someValue) === -1) { myArray.push(someValue); } } }); resolve(myArray)); }, function(err) { reject(err); });</LI-CODE><P>The FeatureLayer that we're querying has the supportsAdvancedQueries set to true.&nbsp;&nbsp;ESRI’s documentation says Distinct is supported if the layer has the supportsAdvancedQueries option set to true.</P><P class="xmsonormal"><A href="https://developers.arcgis.com/javascript/3/jsapi/query-amd.html#returndistinctvalues" target="_blank">https://developers.arcgis.com/javascript/3/jsapi/query-amd.html#returndistinctvalues</A></P><P>Thanks for any insight or assistance.</P> Tue, 09 Mar 2021 17:38:05 GMT https://community.esri.com/t5/arcgis-javascript-maps-sdk-questions/querytask-distinct-geometry-query/m-p/1034560#M71987 AndyWhitaker1 2021-03-09T17:38:05Z