topic Re: Simple Search (Widget) in ArcGIS Viewer for Flex Questions

Simple Search (Widget)

BarryHill1 — Tue, 23 Apr 2013 12:05:59 GMT

Can someone please help me on the code for a simple search...I wish users to be able to search a layer item and need the code that will return the value. But I need the code that returns when the request is NOT Case Sensitive or name is partially selected. For example: Selecting a text item = 'Name' , but will return the value if the user inputs 'name' or 'Nam'.

I am still using Flex 2.4 on ArcGIS for Server 10.0

<?xml version="1.0" ?>
<configuration>
    <layers>
        <layer>
            <name>Lease Parcels</name>
            <url>http://portgis/Arcgis10/rest/services/FlexTest/MapServer/1</url>
            <expression>Tenant like '[value]'</expression>
<textsearchlabel>Search by Tenant Name [ Example: Martin Marietta or Mart%]</textsearchlabel>
            <titlefield>Tenant</titlefield>
            <linkfield>PDF Hyperlink</linkfield>
            <fields all="true"/>
        </layer>
    </layers>
    <zoomscale>10000</zoomscale>
</configuration>

What am I missing? Thank you.

Re: Simple Search (Widget)

RobertScheitlin__GISP — Tue, 23 Apr 2013 12:09:07 GMT

Barry,

It is basic SQL syntax you are missing:

<expression>Upper(Tenant) LIKE Upper('[value]%')</expression>

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

Re: Simple Search (Widget)

BarryHill1 — Tue, 23 Apr 2013 17:39:33 GMT

Robert,

In my sql strings, should I have the code for Tenant in quotes?

<expression>Upper("Tenant") LIKE Upper('[value]%')</expression>

No matter what I do I'm getting an error message:

[RPC Fault faultString="Unable to complete opration."
faultCode="400" faultDetail="Unable to complete Query operation."]

Re: Simple Search (Widget)

RobertScheitlin__GISP — Tue, 23 Apr 2013 17:46:30 GMT

Barry,

Tenant should not be in quotes. Double check the CaSe of the field name and ALL the field names you are sending in the Query as you will get that error if you are sending a field the does not exist as one of the outfields for the query.

Re: Simple Search (Widget)

RobertScheitlin__GISP — Tue, 23 Apr 2013 18:00:22 GMT

Barry,

BTW you missed step 1 of the below graphic:

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