Enhanced Search: Multiple Relate Layers?

[JimLucht]

Hi Folks

I'm trying to get the most out of the super-cool enhanced search widget through a very simple data model. The service contains four iterations of the same parcel shapefile (narrowed by definition queries) that provide useful map and query layers. I want to relate all of them to a single dbf that contains Deeds data. I would eventually want to relate each of them to multiple tables (taking advantage of that intermediate relate-picker screen), but Deeds is enough for now.

The problem I'm having is that while the first layer pulls up related records just fine, the other three layers do not- the relate records icon appears but clicking gives no response (no "No related records found" window, nothing).

The Enhanced Search example provides an illustration of search function for multiple individual layers, one of which as relates enabled (Road Centerlines). It does not show relates enabled on multiple layers.

SO, my question is: Is the Enhanced Search widget geared to provide relates on multiple layers? If so, my code is probably screwed up somewhere but it seems like it should work. Do I need to move to a file geodatabase?

Any help is greatly appreciated!

Test Site: http://mapper.provplan.org/flexviewers/parcelmapper3/

Service (does that relate code with the Deeds relate repeated seem right? In the mxd it has only one relate per layer):
http://mapper.provplan.org/ArcGIS/rest/services/parcel_detail3q/MapServer

Thanks!

Jim

shortened eSearch widget xml:

<?xml version="1.0" ?> <!-- See Enhanced Search Widget XML Configuration.pdf for detailed explanation -->  <configuration>  <layers>   <layer>    <definitionexpression></definitionexpression>    <enableexport>true</enableexport>    <name>Parcels</name>    <url>http://mapper.provplan.org/ArcGIS/rest/services/parcel_detail3q/MapServer/0</url>    <expressions>    <expression alias="Owner Name"      textsearchlabel="Search Owner Name [ Example: smith or Smith ]:">upper(OWNER) LIKE upper('%[value]%')</expression>     <expression alias="Address"      textsearchlabel="Search Address [ Example: 70 Homer ]:">upper(LOCATION) LIKE upper('%[value]%')     </expression>     <expression alias="Plat Lot"      textsearchlabel="Search Plat Lot [ Example: 59 266 ]:">upper(PL) LIKE upper('%[value]%')     </expression>    </expressions>    <graphicalsearchlabel>Use one of the graphical search tools to select     Parcels</graphicalsearchlabel>    <spatialsearchlayer>true</spatialsearchlayer>    <titlefield>LOCATION</titlefield>    <fields all="false">     <field name="LOCATION" alias="Property Address" gridfield="true"/>     <field name="PL" alias="Plat Lot" gridfield="true"/>     <field name="CLASS_DEF" alias="Tax Class" gridfield="true"/>     <field name="OWNER" alias="First Owner" gridfield="true"/>     <field name="OWNER2" alias="Second Owner" gridfield="true"/>     <field name="ZCIVIC" alias="Own StrNum" gridfield="true" gridfieldonly="true"/>     <field name="STREET" alias="Own Str" gridfield="true" gridfieldonly="true"/>     <field name="S_SUFFIX" alias="Type" gridfield="true" gridfieldonly="true"/>     <field name="UNIT" alias="Own Unit" gridfield="true" gridfieldonly="true"/>     <field name="ADD_LINE_B" alias="Own Add1" gridfield="true" gridfieldonly="true"/>     <field name="CITY" alias="Own City" gridfield="true" gridfieldonly="true"/>     <field name="STATE" alias="Own State" gridfield="true" gridfieldonly="true"/>     <field name="ZIP_POSTAL" alias="Own Zip" gridfield="true" gridfieldonly="true"/>     <field name="YR_BUILT" alias="Year Built" gridfield="true" gridfieldonly="true"/>     <field name="EST_RUNITS" alias="Res Units" gridfield="true" gridfieldonly="true"/>     <field name="HSOO" alias="Own Occ 1" gridfield="true" gridfieldonly="true"/>     <field name="NHOOD" alias="Neighborhood" gridfield="true" gridfieldonly="true"/>     <field name="WARD" alias="Ward 2011" gridfield="true" gridfieldonly="true"/>     <field name="CARDURL" alias="Property Card" gridfield="false" hyperlinkgridfield="true" hyperlinkaliastext="Show Card"/>     <field name="PICURL" alias="Photo" gridfield="false" hyperlinkgridfield="true" hyperlinkaliastext="Show Photo"/>    </fields>    <links>     <link includeinresults="false" field="CARDURL" alias="Click for property card">      <linkprefix></linkprefix>      <linksuffix></linksuffix>      <iconfield></iconfield>      <iconprefix></iconprefix>      <iconsuffix>assets/images/i_info.png</iconsuffix>     </link>     <link includeinresults="false" field="PICURL" alias="Click for photo">      <linkprefix></linkprefix>      <linksuffix></linksuffix>      <iconfield></iconfield>      <iconprefix></iconprefix>      <iconsuffix>assets/images/i_camera.png</iconsuffix>     </link>    </links>    <zoomscale usegeometry="true">10000</zoomscale>    <relates>     <relate id="0" label="Deeds Data" enableexport="true">      <fields all="false">       <field name="PL"/>       <field name="PLAT/LOT"/>       <field name="INSTRUMENT"/>       <field name="GRANTOR" />       <field name="GRANTEE" />       <field name="SALEPRICE"/>       <field name="SALEDATE" dateformat="MM/DD/YYYY"/>       <field name="DEEDBOOK"/>       <field name="DEEDPAGE"/>      </fields>     </relate>    </relates>   </layer> <layer>    <definitionexpression></definitionexpression>    <enableexport>true</enableexport>    <name>Non Owner-Occ. Single and 2-5</name>    <url>http://mapper.provplan.org/ArcGIS/rest/services/parcel_detail3q/MapServer/1</url>    <expressions>    <expression alias="Owner Name"      textsearchlabel="Search Owner Name [ Example: smith or Smith ]:">upper(OWNER) LIKE upper('%[value]%')</expression>     <expression alias="Address"      textsearchlabel="Search Address [ Example: 70 Homer ]:">upper(LOCATION) LIKE upper('%[value]%')     </expression>     <expression alias="Plat Lot"      textsearchlabel="Search Plat Lot [ Example: 59 266 ]:">upper(PL) LIKE upper('%[value]%')     </expression>    </expressions>    <graphicalsearchlabel>Use one of the graphical search tools to select     Properties</graphicalsearchlabel>    <spatialsearchlayer>true</spatialsearchlayer>    <titlefield>LOCATION</titlefield>    <fields all="false">     <field name="LOCATION" alias="Property Address" gridfield="true"/>     <field name="PL" alias="Plat Lot" gridfield="true"/>     <field name="CLASS_DEF" alias="Tax Class" gridfield="true"/>     <field name="OWNER" alias="First Owner" gridfield="true"/>     <field name="OWNER2" alias="Second Owner" gridfield="true"/>     <field name="ZCIVIC" alias="Own StrNum" gridfield="true" gridfieldonly="true"/>     <field name="STREET" alias="Own Str" gridfield="true" gridfieldonly="true"/>     <field name="S_SUFFIX" alias="Type" gridfield="true" gridfieldonly="true"/>     <field name="UNIT" alias="Own Unit" gridfield="true" gridfieldonly="true"/>     <field name="ADD_LINE_B" alias="Own Add1" gridfield="true" gridfieldonly="true"/>     <field name="CITY" alias="Own City" gridfield="true" gridfieldonly="true"/>     <field name="STATE" alias="Own State" gridfield="true" gridfieldonly="true"/>     <field name="ZIP_POSTAL" alias="Own Zip" gridfield="true" gridfieldonly="true"/>     <field name="YR_BUILT" alias="Year Built" gridfield="true" gridfieldonly="true"/>     <field name="EST_RUNITS" alias="Res Units" gridfield="true" gridfieldonly="true"/>     <field name="HSOO" alias="Own Occ 1" gridfield="true" gridfieldonly="true"/>     <field name="NHOOD" alias="Neighborhood" gridfield="true" gridfieldonly="true"/>     <field name="WARD" alias="Ward 2011" gridfield="true" gridfieldonly="true"/>     <field name="CARDURL" alias="Property Card" gridfield="false" hyperlinkgridfield="true" hyperlinkaliastext="Show Card"/>     <field name="PICURL" alias="Photo" gridfield="false" hyperlinkgridfield="true" hyperlinkaliastext="Show Photo"/>    </fields>    <links>     <link includeinresults="false" field="CARDURL" alias="Click for property card">      <linkprefix></linkprefix>      <linksuffix></linksuffix>      <iconfield></iconfield>      <iconprefix></iconprefix>      <iconsuffix>assets/images/i_info.png</iconsuffix>     </link>     <link includeinresults="false" field="PICURL" alias="Click for photo">      <linkprefix></linkprefix>      <linksuffix></linksuffix>      <iconfield></iconfield>      <iconprefix></iconprefix>      <iconsuffix>assets/images/i_camera.png</iconsuffix>     </link>    </links>    <zoomscale usegeometry="true">10000</zoomscale>    <relates>     <relate id="0" label="Deeds Data" enableexport="true">      <fields all="false">       <field name="PL"/>       <field name="PLAT/LOT"/>       <field name="INSTRUMENT"/>       <field name="GRANTOR" />       <field name="GRANTEE" />       <field name="SALEPRICE"/>       <field name="SALEDATE" dateformat="MM/DD/YYYY"/>       <field name="DEEDBOOK"/>       <field name="DEEDPAGE"/>      </fields>     </relate>    </relates>   </layer>   -----code truncated-------  </configuration>

[RobertScheitlin__GISP]

Dean,

   You can download the widget from here:

http://www.arcgis.com/home/item.html?id=5d4995ccdb99429185dfd8d8fb2a513e