topic Re: WAB eSearch "parcel between x and y" in ArcGIS Web AppBuilder Questions

WAB eSearch "parcel between x and y"

WilliamBailey — Thu, 22 Sep 2016 15:11:16 GMT

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.

Re: WAB eSearch "parcel between x and y"

RobertScheitlin__GISP — Thu, 22 Sep 2016 16:02:11 GMT

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.

Re: WAB eSearch "parcel between x and y"

WilliamBailey — Thu, 22 Sep 2016 17:29:58 GMT

Parcel is a string, query works in TSQL.

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

Re: WAB eSearch "parcel between x and y"

RobertScheitlin__GISP — Thu, 22 Sep 2016 17:51:55 GMT

William,

Yes you can. What does the SQL look like?

Re: WAB eSearch "parcel between x and y"

WilliamBailey — Thu, 22 Sep 2016 18:40:39 GMT

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

}