topic Re: trying to SELCET DISTINCT with layer.queryFeatures(query); in ArcGIS JavaScript Maps SDK Questions

trying to SELCET DISTINCT with layer.queryFeatures(query);

eyalj — Sun, 02 Jan 2022 14:21:45 GMT

Hi,

I'm trying to do SELECT DISTINCT or do something equivalent with layer.queryFeatures(query);

what should the values of query should be?

Kishore — Mon, 03 Jan 2022 07:04:00 GMT

@eyalj - you can define the return distinct in the query object.

query = new Query(); query.where = "condition"; query.returnDistinctValues = true); layer.queryFeatures(query);

Please refer to the API returnDistinctValues

eyalj — Mon, 03 Jan 2022 07:49:58 GMT

When i change returnDistinctValues to true it says that suddenly i dont have any values,

Kishore — Mon, 03 Jan 2022 08:02:15 GMT

@eyalj - we have known limitations for this:

For service-based queries, this parameter applies only if the supportsAdvancedQueries capability of the layer is true.
Make sure to set returnGeometry to false when returnDistinctValues is true. Otherwise, reliable results will not be returned.

Hope you are comply with these limitations.