Viewer for Flex 2.1 Search Question - newbie

Question

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 GIS_DATA.JOINTABL.SITEADD = '%SearchText%' & GIS_DATA.JOINTABL.SITEADD = [value] PLEASE HELP THE NEWBIE

SallyGracia · Answer

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

SallyGracia · Answer

Sally, Could it be a case sensitive issue? Tryupper(GIS_DATA.JOINTABL.SITEADD) = upper('[value]') Still get loading. I dont understand why I can query from the rest service and do a graphical search and it works fine.

RobertScheitlin__GISP · Answer

Sally, Could it be a case sensitive issue? Tryupper(GIS_DATA.JOINTABL.SITEADD) = upper('[value]')