Viewer for Flex 2.1 Search Question - newbie

528
6
11-04-2010 11:37 AM
SallyGracia
New Contributor II
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
Tags (2)
0 Kudos
6 Replies
RobertScheitlin__GISP
MVP Emeritus
Sally,

  Try

<expression>GIS_DATA.JOINTABL.SITEADD = '[value]'</expression>
0 Kudos
SallyGracia
New Contributor II
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
0 Kudos
SallyGracia
New Contributor II
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>
0 Kudos
RobertScheitlin__GISP
MVP Emeritus
Sally,

   Could it be a case sensitive issue?

Try
<expression>upper(GIS_DATA.JOINTABL.SITEADD) = upper('[value]')</expression>
0 Kudos
SallyGracia
New Contributor II
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.
0 Kudos
SallyGracia
New Contributor II
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
0 Kudos