nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

eSearch error when searching multiple fields

JustinFultz

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&gt;             <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!!!

Vind meer berichten getagd met

Accepted answers

RobertScheitlin__GISP

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>

All comments

ThanosDoganis

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.

JacobBoyle

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!

JacobBoyle

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.

RobertScheitlin__GISP

Jacob,

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

JacobBoyle

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&gt;
   <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...

JacobBoyle

Robert,

I am able to query against the data in the REST

screengrab2.png

RobertScheitlin__GISP

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.

JacobBoyle

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.

RobertScheitlin__GISP

Jacob,

Do both expressions give you the error?

JacobBoyle

It is a text field.

Screengrab.png

RobertScheitlin__GISP

Jacob,

Is your AGMT_NUM field numeric or text?

JacobBoyle

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&gt;
   <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.

RobertScheitlin__GISP

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:

JustinFultz

Thanks Robert! That did the trick.

RobertScheitlin__GISP

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>

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.