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; } } }

WAB eSearch and uniquevalsfromfield

WilliamBailey

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"

Untitled.png

Hermione.jpg

Designer Pass Location to Survey123.png

Find more posts tagged with

Accepted answers

RobertScheitlin__GISP

William,

If the field SUBDIVISION_NAME has a coded domain applied to it then eSearch will automatically populate a dropdown with the coded values.

All comments

WilliamBailey

The domain is working as expected, thank you.

Can this drop-down now become multi-select ??

RobertScheitlin__GISP

William,

If the field SUBDIVISION_NAME has a coded domain applied to it then eSearch will automatically populate a dropdown with the coded values.

WilliamBailey

The only limitation with userlist/predefined is that the list changes when new subs are added and there are 3,800 unique sub names, the manual list will get quite awkward.

Please explain and/or point to sample where a domain is used in eSearch if possible. (I do have a domain that is re-built every night)

thank you for your time

RobertScheitlin__GISP

William,

172k records is a bit to go through to get unique values for. Since I can see you are wanting a drop down of your sub division name then you should just use the predefined list option in the eSearch instead of unique that has to run a query on every 1k of records until it gets all 172k and then loop through to get the unique ones to add to the list. Using the predefined you manually have to add the subs one time and the widget will create a drop down from those values.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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