topic eSearch Query not working for some expressions in Web AppBuilder Custom Widgets Questions

eSearch Query not working for some expressions

TomLeMahieu — Tue, 16 Feb 2016 21:46:47 GMT

Using the eSearch expression configuration, I am able to build my queries. The problem is that some work and others don't.

For example:

CVTTAXDESCRIPTION = 'CITY OF BIRMINGHAM' 9000+ records

SCHOOLDESCRIPTION ='BIRMINGHAM CITY SCH'           0 records
CLASSDESCRIPTION = 'RES IMP (INCLUDES PRIOR SI-SUBURBAN IMP.)'      0 records
Upper(NEIGHBORHOODCODE) =Upper('36H')                                                       200+

The ones returning 0 records return the message "No results" immediately. It's confusing because as you can see below, SCHOOLDESCRIPTION ='BIRMINGHAM CITY SCH' should produce results. And furthermore, CVTTAXDESCRIPTION = 'CITY OF BIRMINGHAM' does produce results.

Do you have any idea what I may be missing?

Tom

Re: eSearch Query not working for some expressions

RobertScheitlin__GISP — Tue, 16 Feb 2016 23:12:08 GMT

Tom,

If you were to add this search expression using the widgets GUI and the field is a type string the the SQL generated by the GUI would normally be:

Upper(SCHOOLDESCRIPTION) = Upper('[value]')

You may want to use the contains option in the GUI which would result in a SQL expression like this:

Upper(SCHOOLDESCRIPTION) LIKE Upper('%[value]%')

Re: eSearch Query not working for some expressions

TomLeMahieu — Wed, 17 Feb 2016 13:32:43 GMT

Robert,

That fixed it! Thanks!!

Tom