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

[eyalj]

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 · Accepted solution]

@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]

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

[Kishore · Accepted solution]

@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.