nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

returnDistinctValues not returning distinct

jamesmuir

I am trying to perform a query to return distinct values from my map service running on 10.1. The returned result has 1000 records (the max set in the server) and when i inspect it I am seeing duplicate values. Here is my code.

var queryTask = new esri.tasks.QueryTask(layerServiceUrl);             var query = new esri.tasks.Query();             query.where = "1=1";             query.outFields = [];             query.outFields.push(field);             query.returnDistinctValues = true;

Can someone tell me what I am doing wrong?

タグ付けされた投稿をもっと見る

Accepted answers

kenbuja

That is not a property of Query yet. Take a look at this thread.

All comments

Anonymous User

Yes, implementing this is under consideration. In the mean time, it is possible to do with the current release of the JavaScript API (but without a nice and clean name like returnDistinctValues). The solution is to add the "esri/tasks/StatisticDefinition" module to your project. Then do the following:

1) Set the statistics type to "count" (see doc, statisticdefinition-amd | API Reference | ArcGIS API for JavaScript)

2) Set groupByFeildsForStatistics to the field of interest (see doc, query-amd | API Reference | ArcGIS API for JavaScript )

The result will be a short list of distinct values with respective feature counts. Hope this helps.

-Doug

PS or go with what Kelly suggests in the post Robert refers too.

KenDoman

As a side note, this hack doesn't work if you're using QueryTask.executeForCount. There's probably other places it doesn't work. We anxiously await the next release.

RobertScheitlin__GISP

All,

This has been brought back to the attention of the JavaScript API team for inclusion in the next release:

See this thread:

returnDistinctValues‌

KenDoman

For a temporary hack until the Query property supports the feature, try tacking it into your QueryTask url definition. It may not work in all cases.

example: var qtask = new QueryTask(url + "?returnDistinctValues=true");

jamesmuir

Unfortunately, you are correct. Thank you.

kenbuja

That is not a property of Query yet. Take a look at this thread.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.