eSearch widget with relate table question

BeckyCarr — Wed, 08 Aug 2012 13:23:13 GMT

When trying to run this widget I get Error #1090. This is my first attempt with this widget and probably not understanding.
Basically, just trying to search info from the related table. Any help is appreaciated. Thanks.

<configuration>
<layers>
   <layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Sites</name>
   <url>http://ngnha7-gis-01/ArcGIS/rest/services/Real_Property/Projects/MapServer/0</url>
   <expressions>
    <expression alias="Site Name" textsearchlabel="Search by Site Name:">
     <values>
      <value prompt="Example: BERLIN" field="feat_name"</value>
     </values>
    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Site</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>Name</titlefield>
   <fields all="false">
    <field name="feat_name" gridfield="true" />
    <field name="instln_id" gridfield="true" />
   </fields>
   <links>
   </links>
   <zoomscale usegeometry="true" zoompercent="1.6" />
   <autoopendatagrid>true</autoopendatagrid>
   <relates>
    <relate id="0"label="Projects" enableexport="true" icon="assets/images/i_hydro.png">
     <fields all="true">
    </relate>
   </relates>
   <zoomscale usegeometry="true" zoompercent="2"></zoomscale>
   <autoopendatagrid>true</autoopendatagrid>
   </layer>
</layers>
   <zoomscale usegeometry="true" zoompercent="2"></zoomscale>
<tables>
<table>
   <definitionexpression></definitionexpression>
   <enableexport></enableexport>
   <name></name>
   <url></url>
   <expressions>
    <expression </expression>
   </expressions>
   <titlefield></titlefield>
   <fields </fields>
   <links>
   </links>
   <queryattachments></queryattachments>
</table>
</tables>
<keepgraphicalsearchenabled>true</keepgraphicalsearchenabled>
<autozoomtoresults>true</autozoomtoresults>
<enabledatagridinteractionwithwidget>true</enabledatagridinteractionwithwidget>
<toleranceforpointgraphicalselection>6</toleranceforpointgraphicalselection>
<tolerancebydefault>false</tolerancebydefault>
<spatialreference>102003</spatialreference>
<zoomscale>2400</zoomscale>
<geometryservice>http://tasks.arcgisonline.com/ArcGIS/rest/services/Geometry/GeometryServer</geometryservice>
<csvseparator>,</csvseparator>
<disablebuttons></disablebuttons>
<defaultselectionoption>textInput</defaultselectionoption>
<enabledrawgraphicbutton>true</enabledrawgraphicbutton>
<enablebuffergraphicbutton>true</enablebuffergraphicbutton>
<selectedgraphicaltool></selectedgraphicaltool>
<multipartgraphicsearch>true</multipartgraphicsearch>
<floatorfixed>fixed</floatorfixed>
<relatetooltip>Show Relates</relatetooltip>
<relateicon>widgets/eSearch/assets/images/i_relate.png</relateicon>
<labels>
<bufferusergraphics>Buffer Graphic</bufferusergraphics>
<norelatesfound>No related features found for: </norelatesfound>
<norelatesfoundalerttitle>No Results</norelatesfoundalerttitle>
<addtolerance>Add search tolerance to point selection</addtolerance>
<existingdrawgraphicslabel>Use Existing eDraw Widget Graphics</existingdrawgraphicslabel>
<existingbuffergraphicslabel>Use Existing Point Buffer Widget Graphics</existingbuffergraphicslabel>
<graphicalsearchlabel>Graphical Search</graphicalsearchlabel>
<textsearchlabel>Text Search</textsearchlabel>
<resultslabel>Results</resultslabel>
<layerlabel>Search Layer:</layerlabel>
<layerfieldlabel>Search Layer Field:</layerfieldlabel>
<nolayerlabel>No search layer defined.</nolayerlabel>
<submitlabel>Search</submitlabel>
<pointlabel>Select by Point</pointlabel>
<linelabel>Select by Line</linelabel>
<rectanglelabel>Select by Rectangle</rectanglelabel>
<polygonlabel>Select by Polygon</polygonlabel>
<clearlabel>Clear</clearlabel>
<loadinglabel>Loading...</loadinglabel>
<selectionlabel>Features Selected:</selectionlabel>
<gridresultslabel>Show Results in Grid</gridresultslabel>
<csvdefaultname>Selected Records</csvdefaultname>
<relatescsvdefaultname>Related Records</relatescsvdefaultname>
<exportbtnlabel>Export...</exportbtnlabel>
<export2csvoptionlabel>Export to CSV...</export2csvoptionlabel>
<export2txtoptionlabel>Export to Txt...</export2txtoptionlabel>
<bufferlabel>apply a search distance:</bufferlabel>
<spatialsearchlabel>Spatial search</spatialsearchlabel>
<applybufferlabel>Apply buffer</applybufferlabel>
<searchlayerlabel>Search entities of:</searchlayerlabel>
<enablemultipartsearch>enable multi-part graphics</enablemultipartsearch>
<zoomalllabel>Zoom</zoomalllabel>
<zoomalltip>Zoom to all results</zoomalltip>
<bufferalpha>Adjust buffer alpha</bufferalpha>
<buffercolor>Select buffer color</buffercolor>
</labels>
<symbols>
<simplefillsymbol color="0xff0000" alpha="0.5">
   <outline color="0xff0000" alpha="0.8" width="2" />
</simplefillsymbol>


<picturemarkersymbol url="assets/images/i_search.png" height="30" width="30" xoffset="0" yoffset="0" />
<simplelinesymbol color="0xff0000" alpha="0.8" width="2" />
</symbols>
</configuration>

Re: eSearch widget with relate table question

RobertScheitlin__GISP — Wed, 08 Aug 2012 13:39:38 GMT

Becky,

What version of the widget are you using?

This expression value is all messed up:

<value prompt="Example: BERLIN" field="feat_name"</value>

It should look like this:

<value prompt="Example: BERLIN">upper(feat_name) LIKE upper('[value]%')</value>

or something close. You have many examples of the proper syntax in the SearchWidget.xml that came with the download.

Re: eSearch widget with relate table question

BeckyCarr — Wed, 08 Aug 2012 14:30:38 GMT

Made that change, now getting the #1085 error. I'm using 3.0. I'll keep checking the syntax. Thanks.

Re: eSearch widget with relate table question

RobertScheitlin__GISP — Fri, 10 Dec 2021 21:43:18 GMT

Becky,

I see one other syntax error:

            <relates>
                <relate id="0" label="Projects" enableexport="true" icon="assets/images/i_hydro.png">
                    <fields all="true">
                </relate>
            </relates>

Needs to be:

            <relates>
                <relate id="0" label="Projects" enableexport="true" icon="assets/images/i_hydro.png">
                    <fields all="true"/>
                </relate>
            </relates>

Re: eSearch widget with relate table question

BeckyCarr — Wed, 08 Aug 2012 14:53:27 GMT

And...back to getting the #1090 error again. I'll keep working on it. Thanks again.

Re: eSearch widget with relate table question

RhettZufelt — Sun, 12 Dec 2021 15:57:23 GMT

how about this?

<tables><!-- This section is ONLY for tables (i.e. data that has no geometry)! -->
<table>
<definitionexpression></definitionexpression>
<enableexport></enableexport>
<name></name>
<url></url>
<expressions>
<expression></expression>
</expressions>
<titlefield></titlefield>
<fields></fields>
<links>
</links>
<queryattachments></queryattachments>
</table>
</tables>

Re: eSearch widget with relate table question

BeckyCarr — Wed, 08 Aug 2012 15:48:30 GMT

R,
Thank you!! That got rid of the errors. Now, I'm not getting a relate result, but I'm at least getting the Search result.

Re: eSearch widget with relate table question

BeckyCarr — Mon, 13 Aug 2012 12:10:12 GMT

I'm using 3.0.4 esearch. No more errors. Relate shows in directory. Search works, but no relate window comes up.

topic Re: eSearch widget with relate table question in ArcGIS Viewer for Flex Questions

eSearch widget with relate table question

Re: eSearch widget with relate table question

Re: eSearch widget with relate table question

Re: eSearch widget with relate table question

Re: eSearch widget with relate table question

Re: eSearch widget with relate table question

Re: eSearch widget with relate table question

Re: eSearch widget with relate table question