topic Re: Viewer for Flex 2.1 Search Question - newbie in ArcGIS API for Flex Questions

Viewer for Flex 2.1 Search Question - newbie

SallyGracia — Thu, 04 Nov 2010 18:37:41 GMT

I am trying to do a search on a string field. I have been successful to do an APN search but cannot get another field to work. The APN is the following and works PERFECTLY!!
(Type: esriFieldTypeInteger, Alias: GIS_DATA.ONTARIO_PLAN_VIEW.APN)

The field that does NOT work is GIS_DATA.JOINTABL.SITEADD
(Type: esriFieldTypeString, Alias: GIS_DATA.JOINTABL.SITEADD)

I have tried <expression>GIS_DATA.JOINTABL.SITEADD = '%SearchText%'</expression> & <expression>GIS_DATA.JOINTABL.SITEADD = [value]</expression>

PLEASE HELP THE NEWBIE

Re: Viewer for Flex 2.1 Search Question - newbie

RobertScheitlin__GISP — Thu, 04 Nov 2010 18:55:55 GMT

Sally,

Try

<expression>GIS_DATA.JOINTABL.SITEADD = '[value]'</expression>

Re: Viewer for Flex 2.1 Search Question - newbie

SallyGracia — Thu, 04 Nov 2010 19:11:12 GMT

Sally,

Try

<expression>GIS_DATA.JOINTABL.SITEADD = '[value]'</expression>

Thanks Now the graphical search works but the entry field does not. I just get LOADING

Re: Viewer for Flex 2.1 Search Question - newbie

SallyGracia — Thu, 04 Nov 2010 19:13:34 GMT

Thanks Now the graphical search works but the entry field does not. I just get LOADING

This is what I have. Everything does get returned with the graphical search

<layer>
            <name>Search By Address</name>
            <url>http://ont-charcsvr01/ArcGIS/rest/services/BaseMap/MapServer/6</url>
            <expression>GIS_DATA.JOINTABL.SITEADD = '[value]'</expression>
            <textsearchlabel>Search By Addrress [ Example: ]:</textsearchlabel>
            <graphicalsearchlabel>Use one of the graphical search tools to select incidents</graphicalsearchlabel>
            <titlefield>GIS_DATA.JOINTABL.SITEADD</titlefield>
            <linkfield></linkfield>
            <fields all="false">
                <field name="GIS_DATA.ONTARIO_PLAN_VIEW.APN"/>
                <field name="GIS_DATA.JOINTABL.SITEADD"/>
                <field name="GIS_DATA.ONTARIO_PLAN_VIEW.ACREAGE"/>
                <field name="GIS_DATA.JOINTABL.OWNER_FULL_NAME"/>
                <field name="GIS_DATA.JOINTABL.MAILADDRES"/>
                <field name="GIS_DATA.JOINTABL.MAILLINE2"/>
                <field name="GIS_DATA.JOINTABL.LEGAL1"/>
                <field name="GIS_DATA.JOINTABL.CONDO"/>
                <field name="GIS_DATA.ONTARIO_PLAN_VIEW.GP92"/>
                <field name="GIS_DATA.JOINTABL.NUMBER_COMMERCIAL_UNITS"/>
                <field name="GIS_DATA.JOINTABL.YEAR"/>
                <field name="GIS_DATA.JOINTABL.BLDG_SF"/>
                <field name="GIS_DATA.JOINTABL.PA"/>
                <field name="GIS_DATA.JOINTABL.CENSUS_TRACT"/>
                <field name="GIS_DATA.JOINTABL.SCHOOL_DISTRICT"/>
                <field name="GIS_DATA.ONTARIO_PLAN_VIEW.HIST_DES_STAT"/>
                <field name="GIS_DATA.JOINTABL.SOIL_DESC"/>
            </fields>
        </layer>

Re: Viewer for Flex 2.1 Search Question - newbie

RobertScheitlin__GISP — Thu, 04 Nov 2010 19:22:36 GMT

Sally,

Could it be a case sensitive issue?

Try

<expression>upper(GIS_DATA.JOINTABL.SITEADD) = upper('[value]')</expression>

Re: Viewer for Flex 2.1 Search Question - newbie

SallyGracia — Thu, 04 Nov 2010 19:36:56 GMT

Sally,

Could it be a case sensitive issue?

Try
<expression>upper(GIS_DATA.JOINTABL.SITEADD) = upper('[value]')</expression>

Still get loading. I dont understand why I can query from the rest service and do a graphical search and it works fine.

Re: Viewer for Flex 2.1 Search Question - newbie

SallyGracia — Thu, 04 Nov 2010 19:40:20 GMT

Still get loading. I dont understand why I can query from the rest service and do a graphical search and it works fine.

I am trying to search a field from the joined table. If so I dont understand why the graphical search works and returns all the fields from the joined table including the Siteadd