eSearch Sql With And Operator and No Response

1503
1
02-11-2016 10:52 AM
TomLeMahieu
New Contributor II

In the eSearch by Value configuration, is it possible to configure a "No Selection" in the Combobox as a default.  Furthermore, if there is a no selection, then it is possible to have it disregarded in the query?  For example, in the selection below, if the user wants to select "CVT" and "Nbrhd" only, the query also includes "SCHOOLDESCRIPTION".

SCHOOLDESCRIPTION = 'ROCHESTER COMM SCHLS' AND CVTTAXDESCRIPTION = 'CITY OF ROCHESTER HILLS' AND NEIGHBORHOODCODE = 'CME'

Tags (1)
0 Kudos
1 Reply
RobertScheitlin__GISP
MVP Esteemed Contributor

Tom,

   Are you using Unique values options or predefined or does the field have a domain? If the field is not configured as required and the blank/empty string option is chosen in the drop down then that field will not be added to the SQL string (this is the way it currently works). If the field is coming from a domain, or unique and you have not configured it as a required field then a blank string will be added automatically.

0 Kudos