AnsweredAssumed Answered

Question about distinct (unique) values on Search Field - eSearch

Question asked by jeff.pace on Jul 30, 2018
Latest reply on Jul 31, 2018 by rscheitlin

Robert, 

 We are struggling to use the eSearch Widget.  Would love to use it as it fits almost all our needs but one.

 

When we choose unique values on a field, instead of using the get distinct JSON API function, it is doing 10k's querys by groups of objectid.  With 230k records, this takes minutes for the widget to load and be ready

 

Using get distinct we can get the distinct list back in 0.5seconds. 

 

IS there any way to improve the performance?

 

I am at Portal 10.5.1 at the moment

 

https://www.mymanatee.org/arcgis01/rest/services/commonoperational/parcellines/MapServer/0/query?where=1%3D1&text=&objec… 

 

Robert Scheitlin, GISP

Outcomes