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. true Sites http://ngnha7-gis-01/ArcGIS/rest/services/Real_Property/Projects/MapServer/0 Use one of the graphical search tools to select Site true Name true true true true true 6 false 102003 2400 http://tasks.arcgisonline.com/ArcGIS/rest/services/Geometry/GeometryServer , textInput true true true fixed Show Relates widgets/eSearch/assets/images/i_relate.png Buffer Graphic No related features found for: No Results Add search tolerance to point selection Use Existing eDraw Widget Graphics Use Existing Point Buffer Widget Graphics Graphical Search Text Search Results Search Layer: Search Layer Field: No search layer defined. Search Select by Point Select by Line Select by Rectangle Select by Polygon Clear Loading... Features Selected: Show Results in Grid Selected Records Related Records Export... Export to CSV... Export to Txt... apply a search distance: Spatial search Apply buffer Search entities of: enable multi-part graphics Zoom Zoom to all results Adjust buffer alpha Select buffer color -->

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

eSearch widget with relate table question

BeckyCarr

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>

Vind meer berichten getagd met

Accepted answers

All comments

RobertScheitlin__GISP

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.

BeckyCarr

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

RobertScheitlin__GISP

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>

BeckyCarr

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

RhettZufelt

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>

BeckyCarr

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.

BeckyCarr

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.