AnsweredAssumed Answered

eSearch SQL query issue

Question asked by mcavoye on Aug 24, 2017
Latest reply on Nov 17, 2017 by rscheitlin

Good morning!


I am starting a new thread here at the request of Robert Scheitlin, GISP to attempt to solve this issue.


I'm having a weird issue and I'm hoping you might be able to help me out. We've been using the eSearch for more than a year now and it has worked flawlessly the entire time. Our 2.4 Web App is using eSearch Version 2.3. Early last week, the Search by Value ceased working as it had and started returning no results. This search for Survey numbers containing "CS1" should return hundreds of results.

The query it sends to the service should be

Upper(DocumentNa) LIKE Upper('%cs1%')

but instead it is sending the entire query regardless of the entered parameters. 

Upper(DocumentNa) LIKE Upper('%cs1%') AND Upper(SurveyorKe) LIKE Upper('%%') AND Upper(Subdivisio) LIKE Upper('%%') AND Upper(ClerkNumbe) LIKE Upper('%%')

The issue exists in IE, Firefox, and Chrome versions 59 and 60. No errors show in the DEV Console.