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 "parcel between x and y"

WilliamBailey

Rich,

I see Flexviewer eSearch posts mentioning "between" queries.

I have need in WAB for sql like this: " Parcel between 'x' and 'y' "

Will result in collection of parcels based on a range where x and y are typed in by user.

Please point me in the right direction.

p.s. Keep up the good work on your widgets, love em.

Find more posts tagged with

Accepted answers

RobertScheitlin__GISP

William,

Yes you can. What does the SQL look like?

All comments

WilliamBailey

All is working as expected, thanks again

TSQL:

where parcel_key >= '1720305TH00000000' and parcel_key <= '18203030099999999'

Config:

{

"fieldObj": {

"name": "PARCEL_KEY",

"label": "PARCEL_KEY",

"shortType": "string",

"type": "esriFieldTypeString"

"valueObj": {

"value": "Low Parcel Number"

"prompt": "PARCEL_KEY is >=",

"textsearchhint": "Low Parcel Number",

"sqltext": "Upper(PARCEL_KEY) >= Upper('[value]')",

"operation": "stringOperatorIs",

"required": true

{

"fieldObj": {

"name": "PARCEL_KEY",

"label": "PARCEL_KEY",

"shortType": "string",

"type": "esriFieldTypeString"

"valueObj": {

"value": "High Parcel Number"

"prompt": "PARCEL_KEY is <=",

"textsearchhint": "High Parcel Number",

"sqltext": "Upper(PARCEL_KEY) <= Upper('[value]')",

"operation": "stringOperatorIs",

"operator": "AND",

"required": true

}

RobertScheitlin__GISP

William,

Yes you can. What does the SQL look like?

WilliamBailey

Parcel is a string, query works in TSQL.

Can I edit config_Enhanced Search.json in configs\eSearch ?

RobertScheitlin__GISP

William,

If you are searching by a numeric parcel number the you can easily do a greater than x AND less than Y query in the WAB eSearch widget. just add two expression values when using the settings dialog for the query expression.

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.