topic Re: eSearch error when searching multiple fields in ArcGIS Viewer for Flex Questions

eSearch error when searching multiple fields

JustinFultz — Mon, 27 Aug 2012 20:10:12 GMT

I am trying to search using multiple fields on the Enhanced search widget, version 2.9.0. I am at flex version 2.5 and recently upgraded my search widget to 2.9 specifically for this functionality. Everything is working as it should except when I add a second value in a search I get the follwoing error: RPC Fault faultStign-"Unable to complete operation." faultCode="400" faultDetail="Unable to complete Query operation."

I am able to do each search seperately, so I don't know what the issue is.

Here is my code:

<layer>    <definitionexpression></definitionexpression>    <enableexport>false</enableexport>    <name>Generation</name>               <url>http://dcpgisav/ArcGIS/rest/services/Operations/Generation/MapServer/0</url>             <expressions>              <expression alias="EMS Name" textsearchlabel="Search EMS Name:">               <values>                 <value prompt="Example: ARSENAL">upper(EMS_STATION_NAME) like upper('%[value]%')</value>                </values>              </expression>              <expression alias="Balancing Authority" textserachlabel="Select Balancing Authority...">               <values>                <value prompt="Select an area:" field="CTRLAREA" usedomain="true">CTRLAREA = '[value]'</value>                <value prompt="Select a fuel type:" field="PRIMARY_FUEL" usedomain="true">PRIMARY_FUEL = '[value]'</value>               </values>              </expression>             </expressions>

Any help is appreciated!!!

Re: eSearch error when searching multiple fields

RobertScheitlin__GISP — Mon, 27 Aug 2012 20:16:49 GMT

Justin,

You have to have an AND or OR before your second SQL expression.

                    <values>                         <value prompt="Select an area:" field="CTRLAREA" usedomain="true">CTRLAREA = '[value]'</value>                         <value prompt="Select a fuel type:" field="PRIMARY_FUEL" usedomain="true"> AND PRIMARY_FUEL = '[value]'</value>                     </values>

Re: eSearch error when searching multiple fields

JustinFultz — Mon, 27 Aug 2012 20:19:51 GMT

Thanks Robert! That did the trick.

Re: eSearch error when searching multiple fields

RobertScheitlin__GISP — Mon, 27 Aug 2012 20:24:26 GMT

Justin,

Don't forget to click the Mark as answer check on this post and to click the top arrow (promote).
Follow the steps as shown in the below graphic:

Re: eSearch error when searching multiple fields

JacobBoyle — Sun, 12 Dec 2021 00:17:56 GMT

I'm having the same error, here's a copy of my code. I'm not sure what exactly is causing the issue.

<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>SRC Land Data</name>
   <url>http://pit-arcgis/arcgis/rest/services/Land/PA_Land_Data/MapServer/10</url>
   <expressions>
    <expression alias="Agreement Number" textsearchlabel="Search Agreement Number:">
     <values>
      <value prompt="Example: 061853" >upper(AGMT_NUM) like upper('%[value]%')</value>
     </values>
    </expression>
    <expression alias="Lessor" textsearchlabel="Search Lessor:">
     <values>
      <value prompt="Example: Bob Smith">upper(LESSOR) = upper('[value]')</value>
     </values>
    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Land Data</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>AGMT_NUM</titlefield>
   <fields all="false">
    <field name="AGMT_NUM" alias="Agreement Number" gridfield="true"/>
    <field name="LESSOR" alias="Lessor" gridfield="true" />
    <field name="LEASE_DATE" gridfield="true" alias="Lease Date" dateformat="MM/DD/YYYY" />
    <field name="LEASE_YEAR" gridfield="true" alias="Lease Year" />
    <field name="EXPR_DATE" alias="Expiration Date" gridfield="true" dateformat="MM/DD/YYYY" />
    <field name="CALC_ACRES" alias="Calculated Acreage" gridfield="true" />
    <field name="NET_ACRES" alias="Net Acreage" gridfield="true" />
    <field name="GROSS_ACRES" alias="Gross Acreage" gridfield="true" />
    <field name="RIGHTSSHORT" alias="Rights Short" gridfield="true" />
    <field name="LEASETYPE" alias="Lease Type" gridfield="true" />
    <field name="RIGHTSHELD" alias="Rights Held" gridfield="true" />
    <field name="LEASESTATUS" alias="Lease Status" gridfield="true" />
   </fields>
   <links/>
   <zoomscale usegeometry="true" zoompercent="2"></zoomscale>
  </layer>

any light you can shed on my issue, I'd appriciate.

Re: eSearch error when searching multiple fields

RobertScheitlin__GISP — Mon, 17 Sep 2012 13:56:25 GMT

Jacob,

Is your AGMT_NUM field numeric or text?

Re: eSearch error when searching multiple fields

JacobBoyle — Mon, 17 Sep 2012 13:59:11 GMT

It is a text field.

Re: eSearch error when searching multiple fields

RobertScheitlin__GISP — Mon, 17 Sep 2012 14:14:50 GMT

Jacob,

Do both expressions give you the error?

Re: eSearch error when searching multiple fields

JacobBoyle — Mon, 17 Sep 2012 14:29:32 GMT

Yes, the spatial search doesn't work either.

We upgraded the server this weekend (10.0--> 10.1), I made sure all the services are pointing to the right sources. Other layers I search work from the same server.

Re: eSearch error when searching multiple fields

RobertScheitlin__GISP — Mon, 17 Sep 2012 14:38:33 GMT

Jacob,

You might want to also check if the service can be queried from the rest service directory using similar SQL expression. There has been reports of map services not functioning properly once server has been upgraded so I would republish the service.

Re: eSearch error when searching multiple fields

JacobBoyle — Mon, 17 Sep 2012 15:19:19 GMT

Robert,

I am able to query against the data in the REST

Re: eSearch error when searching multiple fields

JacobBoyle — Sun, 12 Dec 2021 00:17:59 GMT

Robert,

I am able to query against the data in the REST

Robert i changed the following

<definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>SRC Land Data</name>
   <url>http://pit-arcgis/arcgis/rest/services/Land/PA_Land_Data/MapServer/8</url>
   <expressions>
    <expression alias="Agreement Number" textsearchlabel="Search Agreement Number:">
     <values>
      <value prompt="Example: 061853" >AGMT_NUM = '[value]'</value>
     </values>
    </expression>
    <expression alias="Lessor" textsearchlabel="Search Lessor:">
     <values>
      <value prompt="Example: Bob Smith">upper(LESSOR) = upper('[value]')</value>
     </values>
    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Land Data</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>AGMT_NUM</titlefield>
   <fields all="true">

and that fixed it...

Re: eSearch error when searching multiple fields

RobertScheitlin__GISP — Mon, 17 Sep 2012 15:28:10 GMT

Jacob,

So that seems like something is wrong in the field names you are requesting then...

Re: eSearch error when searching multiple fields

JacobBoyle — Sun, 12 Dec 2021 00:18:02 GMT

Well, the search tool works when I set the Fields All= to true, and for any feature class where I set that to false, the queries do not work. the workaround I am trying right now is doing the follofing for the field options:

 <field name="SHAPE" gridfieldonly="true" gridfield="false"/>
    <field name="SHAPE.area" gridfieldonly="true" gridfield="false"/>
    <field name="SHAPE.len" gridfieldonly="true" gridfield="false"/>

This is hiding the fields I do not want to see.

Re: eSearch error when searching multiple fields

JacobBoyle — Mon, 17 Sep 2012 15:45:16 GMT

OK, I've checked every service I am searching against. Only 2 fail, this one and another point layer. Both produce the error until i switch the Field All value to true. Then everything is right as rain. 😄

Robert, thanks for your help and thanks for writing these great tools!

Re: eSearch error when searching multiple fields

ThanosDoganis — Mon, 05 Nov 2012 17:20:39 GMT

OK, I've checked every service I am searching against. Only 2 fail, this one and another point layer. Both produce the error until i switch the Field All value to true. Then everything is right as rain. 😄

Robert, thanks for your help and thanks for writing these great tools!

Dear friends,

I was stucked with the same error for two days. I found out that ESRI renamed area and length fields from SHAPE.area and SHAPE.len
to SHAPE.STArea() and SHAPE.STLength() respectively. You have to update your configuration files when moving flex applications from 10.0 to 10.1.

Robert thanks again for your helpful apps.