AnsweredAssumed Answered

WAB eSearch and uniquevalsfromfield

Question asked by semcopa on Feb 27, 2017
Latest reply on Mar 7, 2017 by rscheitlin

Working with Javascript WAB eSearch widget and uniquevalsfromfield.

It does work, albeit kind of slowly (took a minute to process 172k records)

My users are definitely going to bark about this. (field is unusable until all records are processed)

Is there another way to reference a lookup table with only unique values to populate this drop down?

Or another way I have not thought of, I desperately need to speed this up.

 

 

Code:

{

"fieldObj": {

"name": "SUBDIVISION_NAME",

"label": "Subdivision",

"shortType": "string",

"type": "esriFieldTypeString"

},

"valueObj": {

"value": "%"

},

"prompt": "Subdivision",

"textsearchhint": "",

"sqltext": "SUBDIVISION_NAME LIKE '[value]%'",

"operation": "stringOperatorStartsWith",

"uniquevalsfromfield": "SUBDIVISION_NAME",

"operator": "AND"

},

Attachments

Outcomes