Using Numbers in the Search Widget- Flex Viewer 2.2

MatthewStarr

Perhaps this is an easier answer, but I cannot seem to use numbers (double) in the search widget.  I have edited my expression a number of ways. and as you can see in the config I am using TOTAL_AV in a simple expression, which does not work. (faultCode="400 Error")  I presume i must have my expression wrong, but I have made it as simple as possible. 

However all my query against a string field work fine (PRINT_KEY and LOCATION)

<?xml version="1.0" ?>
<configuration>
    <layers>
        <layer>
            <name>Louisville Police Facilities</name>
            <url>http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Louisville/LOJIC_PublicSafety_Louisville/MapServer/3</url&gt;
            <expression>PD_NAME = '[value]'</expression>
            <textsearchlabel>Search Police Stations by name... [ Example: 2ND DIVISION ]</textsearchlabel>
            <titlefield>PD_NAME</titlefield>
            <linkfield></linkfield>
            <fields all="false">
                <field name="PD_NAME"/>
                <field name="ADDRESS" alias="Address"/>
            </fields>
        </layer>
  <layer>
            <name>PropertyBoundaries</name>
            <url>http://71.176.110.94/ArcGIS/rest/services/CEDA/MapServer/1</url&gt;
            <expression>SWIS = '[value]'</expression>
            <textsearchlabel>Search by Assessed Value  [ Example: 050100 ]:</textsearchlabel>
            <titlefield>SWIS</titlefield>
            <linkfield></linkfield>
            <fields all="true">
                <!--<field name="LOCATION" alias "Address"/>
    <field name="TOTAL_AV"/>
    <field name="Link"/>-->
            </fields>
        </layer>
  <layer>
            <name>PropertyBoundaries2</name>
            <url>http://71.176.110.94/ArcGIS/rest/services/CEDA/MapServer/1</url&gt;
            <expression>TOTAL_AV > '[value]'</expression>
            <textsearchlabel>Search by Assessed Value  [ Example: 59000 ]:</textsearchlabel>
            <titlefield>TOTAL_AV</titlefield>
            <linkfield></linkfield>
            <fields all="true">
                <!--<field name="LOCATION" alias "Address"/>
    <field name="TOTAL_AV"/>
    <field name="Link"/>-->
            </fields>
        </layer>
  <layer>
            <name>PropertyBoundaries3</name>
            <url>http://71.176.110.94/ArcGIS/rest/services/CEDA/MapServer/1</url&gt;
            <expression>LOCATION LIKE '%[value]%'</expression>
            <textsearchlabel>Search by Assessed Value  [ Example: 306 Grant ]:</textsearchlabel>
            <titlefield>LOCATION</titlefield>
            <linkfield></linkfield>
            <fields all="true">
                <!--<field name="LOCATION" alias "Address"/>
    <field name="TOTAL_AV"/>
    <field name="Link"/>-->
            </fields>
        </layer>
    </layers>
    <zoomscale>5000</zoomscale>
    <info>widgets/InfoTemplates/InfoPopupWidget.swf</info>
</configuration>

MatthewStarr

Matthew,

   In SQL Language single quotes are for sting so just drop the single quotes

<expression>TOTAL_AV > [value]</expression>

WOW (rookie mistake)...  thank you for the quick response things are working fine now.  I will be graduating to your eSearch soon.  Thank you for your contributions

-MStarr