AnsweredAssumed Answered

eSearch Sql With And Operator and No Response

Question asked by tjlemahieu on Feb 11, 2016
Latest reply on Feb 11, 2016 by rscheitlin

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'

 

Outcomes