Hello all, I just spent 2 hours looking through almost every forum on this site that has to do with the Enhanced Search Widget, which is awesome by the way. Robert S is the bomb. Anyway, the widget works great until I try to search a field that is located in an Excel spreadsheet. I will explain. I am putting together a gis website and am wanting a parcel search function. So I have the Parcels as a searchable layer in the xml file and I setup 2 expressions. One for the Parcel ID and one for the Owner. When searching by PID it works flawlessly, but searching by a name causes the search widget to think for a while and the spinning icon spins for several minutes then eventually shows the error in the attached image: The data is being displayed just fine when doing a PID search, even the fields from the Excel Spreadsheet. However, when running a query on the PartyName field which is in the spreadhseet, I get the error. So my theory is that the '$' in the table name is what is causing the issue. My code is below. <expressions> <expression alias="Parcel ID" textsearchlabel="Search by Parcel ID [ Example: 010008909 or 0100%]:">PARCELS.PID like '[value]'</expression> <expression alias="Owner Search" textsearchlabel="Search by Property Owner [Example: Smith John (Last name first)]:">upper(Sheet1$OrionNEW.PartyName) like upper('%[value]%')</expression> </expressions> <fields all="false"> <field name="PARCELS.PID" alias="Parcel Id" /> <field name="Sheet1$OrionNEW.PartyName" alias="Property Owner"/> <field name="Sheet1$OrionNEW.PartyAddress" alias="Property Address"/> <field name="Sheet1$OrionNEW.LegalDescription" alias="Legal Desc"/> <field name="PARCELS.acres" alias="Acres"/> </fields>P.S. I pray to the GIS gods that Robert S. sees this post. Thanks for your time everyone.
