topic Re: Problems with Relates and the Enhanced Search Widget in ArcGIS Viewer for Flex Questions

Problems with Relates and the Enhanced Search Widget

GeorgeHaskett — Wed, 12 Sep 2012 01:24:33 GMT

Hello,

I am trying to figure out how to get my relates functions to work with the Enhanced Search Widget.

I have created a relationship between a layer and a table within ArcMap in my mxd document and created a shared service, however I cannot seem to figure out how to get the relate to populate in the grid and get the relate popup window to open.

Can someone explain the basics, seeing how I am somehow missing something?

Does the relate need to happen within the geodatabase instead of the mxd document?

Thanks,

George

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Wed, 12 Sep 2012 11:04:37 GMT

George,

When you published your map service did you go to your REST Service directory and verify that the relate is listed at the bottom of that layer in the service directory?

Re: Problems with Relates and the Enhanced Search Widget

GeorgeHaskett — Wed, 12 Sep 2012 20:12:41 GMT

Rob,

No I'm not seeing that anywhere.

Do you have an example of one I could look at to verify it.

Mine is located at:

http://rd.giscenter.isu.edu/arcgis/rest/services/MCPD_beta/MapServer

Does the relate have to occur at the geodatabase level or can I do it at the layer level within the mxd?

Thanks,

Haskett

Re: Problems with Relates and the Enhanced Search Widget

AnthonyGiles — Wed, 12 Sep 2012 20:28:58 GMT

George,

Here is a Rest endpoint from one of The esri sample servers that has related tables:

http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/Petroleum/KSPetro/MapServer/0

Have you made sure that you have cleared your rest cache after you have made changes to your mxd

Regards

Anthony

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Wed, 12 Sep 2012 20:52:51 GMT

George,

Now that your relates are showing for your map service do you need anything else as far as getting the eSearch setup to work with the relates data? Make sure you use 0 for the relate id based on your REST Service directory: MCPD_SURVEYOR (0) -- Related To: MCPD_SURVEYOR (8).

Re: Problems with Relates and the Enhanced Search Widget

GeorgeHaskett — Wed, 12 Sep 2012 22:34:24 GMT

Thanks everyone.

@Athony - Yeah the cache settings where a major headache until I had them install CCleaner, which seems to be saving me a lot of time. Seeing the link helped me visualize what it should look like. I ended up removing my relate on the map, re-relating it and republishing it. Then the relates appeared on the REST file.

@Rob - Thanks, I managed to finally get it to work. I think part of my problem was the fact I was trying to list the table under the table event in the xml doc.

For future reference, can a layer have more than one related table with this tool?

Thanks,

Haskett

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 13 Sep 2012 01:13:35 GMT

George,

Yes you can have many relates associated with one layer as shown here (one layer from the eSearchWidget.xml that come in the download):

        <!--<layer>             <definitionexpression></definitionexpression>             <enableexport>true</enableexport>             <name>Road Centerlines</name>             <url>http://gislap183/ArcGIS/rest/services/Highway/MapServer/5</url>             <expressions>                 <expression alias="Road Name and Zip" textsearchlabel="Search by Road Name and Left Zipcode and Right Zip:">                     <values>                         <value prompt="Example: ANDREW" isValueRequired="true">RD_NAME = '[value]'</value>                         <value prompt="Example: 36201" isValueRequired="true" operator="AND">ZIP_L = [value]</value>                         <value prompt="Example: 36201" isValueRequired="true" operator="AND">ZIP_R = [value]</value>                     </values>                 </expression>                 <expression alias="Road Surface" textsearchlabel="Search by Surface Type:">                     <values>                         <value prompt="Example: Asphalt" field="Surf_Type" usedomain="true">Surf_Type = [value]</value>                     </values>                 </expression>                 <expression alias="Open SQL" textsearchlabel="Search by Typing Full SQL:">                     <values>                         <value prompt="Example: RD_NAME = 'ANDREW' AND ZIP_L = 36201">[value]</value>                     </values>                 </expression>             </expressions>             <graphicalsearchlabel>Use one of the graphical search tools to select Roads</graphicalsearchlabel>             <spatialsearchlayer>true</spatialsearchlayer>             <titlefield>Name</titlefield>             <fields all="false">                 <field name="Name" gridfield="true" sort="asc|1|string"/>                 <field name="Classification" gridfield="true" />                 <field name="Length_" numberformat="2|,|." />                 <field name="Width" gridfield="true" />                 <field name="L_F_ADD" gridfield="true" />                 <field name="L_T_ADD" gridfield="true" />                 <field name="R_F_ADD" gridfield="true" />                 <field name="R_T_ADD" gridfield="true" />                 <field name="PREFIX" gridfield="true" />                 <field name="PRETYPE" gridfield="true" />                 <field name="RD_NAME" gridfield="true" />                 <field name="TYPE" gridfield="true" />                 <field name="SUFFIX" gridfield="true" />                 <field name="ZIP_L" gridfield="true" />                 <field name="ZIP_R" gridfield="true" />             </fields>             <links>                 <link alias="View Mon. Ref Sheet" diablelinksifnull="true">                     <![CDATA[http://somesite/gis/map/map_search/mrs_test.cfm?mrspoint={xxx}&lat={ZIP_L}&long={ZIP_R}]]>                     <icon><![CDATA[assets/images/w_link.png]]></icon>                 </link>              </links>             <zoomscale usegeometry="true" zoompercent="1.6" />             <autoopendatagrid>true</autoopendatagrid>             <relates>                 <relate id="0" label="ABIMS Bridge" enableexport="true" icon="assets/images/i_hydro.png">                     <fields all="true" />                 </relate>                 <relate id="1" label="Average Daily Traffic" enableexport="true" icon="assets/images/i_flag.png">                     <fields all="false">                         <field name="Date_" dateformat="MM/DD/YYYY" sort="asc|1|date"/>                         <field name="Road_Name" />                         <field name="Road_ID" />                         <field name="Location" />                         <field name="ADT" sum="true" sumlabel="ADT Total Count: " sort="asc|2|numeric"/>                         <field name="Percent_Tr" />                     </fields>                 </relate>                 <relate id="2" label="Railroad Crossings" enableexport="true" icon="assets/images/i_folder.png">                     <fields all="false">                         <field name="Gate" />                         <field name="Lights" />                         <field name="Active" />                         <field name="At_Grade" />                         <field name="Clearance" />                         <field name="Control_Mark" />                     </fields>                 </relate>                 <relate id="3" label="Signs" enableexport="false" icon="assets/images/i_lego.png">                     <fields all="false">                         <field name="Type" />                         <field name="Road_ID" />                         <field name="Condition" />                         <field name="P_Hyper" />                         <field name="Image_" hyperlinkgridfield="true" hyperlinkgridicon="assets/images/i_lego.png"                             hyperlinkaliastext="Get Sign Image" linkprefix="" linksuffix="" />                         <field name="post" />                     </fields>                 </relate>                 <relate id="4" label="Guardrails" enableexport="true" icon="assets/images/i_clock.png">                     <fields all="false">                         <field name="Type" />                         <field name="ID" />                         <field name="Date_P" dateformat="MM/DD/YYYY" />                         <field name="Date_R" dateformat="MM/DD/YYYY" />                         <field name="Type_end_a" />                         <field name="Type_start_a" />                         <field name="Comments" />                     </fields>                 </relate>             </relates>             <queryattachments>false</queryattachments>             <symbology>                 <simplelinesymbol color="0x00ffff" alpha="0.8" width="2" />             </symbology>         </layer>

Re: Problems with Relates and the Enhanced Search Widget

AaronMielke — Thu, 27 Sep 2012 21:10:58 GMT

Robert,
[ATTACH=CONFIG]18059[/ATTACH]
I am having a similar problem. The relate shows up in the REST Service directory but nothing shows up when I click on the folder icon at the bottom of the search results. I have a Sites layer related to a Documents table. The table contains a list of documents associated with each of the sites. I wasn't sure which relate id to use, but I have tried all of them 0 thru 6. I have attached a few screen shots to try and explain.

George,

When you published your map service did you go to your REST Service directory and verify that the relate is listed at the bottom of that layer in the service directory?

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 27 Sep 2012 21:41:08 GMT

Aaron,

The relate id should be 0 in your xml configuration for the relate, always use the first number in parentheses reported by the REST service directory.

Re: Problems with Relates and the Enhanced Search Widget

AaronMielke — Fri, 28 Sep 2012 16:36:34 GMT

Robert,
I tried using ID=0 and it still doesn't work. I can't for the life of me figure out why it wouldn't be working. Can you see anything in the attached Search Widger.xml

<layers>
<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Sites</name>
<url>https://XXXXXXX/ArcGIS/rest/services/Test/Test_Map/MapServer/2</url>
   <expressions>
    <expression alias="Name">
     <values>
      <value userlist="1,2,3,4">upper(Name) = upper('[value]')</value>
     </values>
    </expression>

                                <expression alias="Parcel ID Number" textsearchlabel="Search Parcel ID#:">
     <values>
      <value prompt="Example: 2102924430038 or 2102%"> PID_NO like '[value]'</value>
     </values>
    </expression>

    <expression alias="Address" textsearchlabel="Building Number and Street Name:">
     <values>
      <value prompt="Example: 801">BLDG_NUM = '[value]'</value>
      <value prompt="Example: 2ND AVE N">AND upper(STREETNAME) = upper('[value]')</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="Name" alias="Site Name" gridfield="true"/>
    <field name="BLDG_NUM" alias="Building Number" gridfield="true"/>
    <field name="STREETNAME" alias="Street" gridfield="true"/>
    <field name="City" alias="City" gridfield="true"/>
    <field name="PID_NO" alias="Parcel ID#" gridfield="true"/>

   </fields>

   <zoomscale usegeometry="true" zoompercent="1.6">10000</zoomscale>
   <autoopendatagrid>false</autoopendatagrid>
   <relates>

    <relate id="0" label="Documents" enableexport="true" icon="assets/images/i_folder.png">
     <fields all="true"/>


    </relate>

   </relates>

</layer>

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Sun, 12 Dec 2021 07:21:06 GMT

Aaron,

So I have made a few minor changes but nothing that would prevent the relate from working that I know of.

        <layer>
            <definitionexpression></definitionexpression>
            <enableexport>true</enableexport>
            <name>Sites</name>
            <url>https://XXXXXXX/ArcGIS/rest/services/Test/Test_Map/MapServer/2</url>
            <expressions>
                <expression alias="Name">
                    <values>
                        <value userlist="1,2,3,4">upper(Name) = upper('[value]')</value>
                    </values>
                </expression>
                <expression alias="Parcel ID Number" textsearchlabel="Search Parcel ID#:">
                    <values>
                        <value prompt="Example: 2102924430038 or 2102%"> PID_NO like '[value]'</value>
                    </values>
                </expression>
                <expression alias="Address" textsearchlabel="Building Number and Street Name:">
                    <values>
                        <value prompt="Example: 801">BLDG_NUM = '[value]'</value>
                        <value prompt="Example: 2ND AVE N">AND upper(STREETNAME) = upper('[value]')</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="Name" alias="Site Name" gridfield="true" />
                <field name="BLDG_NUM" alias="Building Number" gridfield="true" />
                <field name="STREETNAME" alias="Street" gridfield="true" />
                <field name="City" alias="City" gridfield="true" />
                <field name="PID_NO" alias="Parcel ID#" gridfield="true" />
            </fields>
            <links />
            <zoomscale usegeometry="true" zoompercent="1.6" />
            <autoopendatagrid>false</autoopendatagrid>
            <relates>
                <relate id="0" label="Documents" enableexport="true" icon="assets/images/i_folder.png">
                    <fields all="true" />
                </relate>
            </relates>
            <queryattachments>false</queryattachments>
        </layer>

My big concern is the URL

<url>https://XXXXXXX/ArcGIS/rest/services/Test/Test_Map/MapServer/2</url>

I have never tested with a https secured url and have no ability to do so, so I don't know if this widget supports https urls.

Re: Problems with Relates and the Enhanced Search Widget

AaronMielke — Fri, 28 Sep 2012 19:39:53 GMT

Robert,
Thanks for your repsonse. All of the other functionality works with https. Just the relate isns't working. A few questions.

1) Have you tested eSearch with data in SDE?
2) Can the relate be a stand alone table or does it have to be a spatial data set?
3) Does it matter if the relate is set up in the data base or in the map?

Thanks,
Aaron

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Fri, 28 Sep 2012 19:48:47 GMT

Aaron,

1) Have you tested eSearch with data in SDE? Yes almost all my data is in SDE
2) Can the relate be a stand alone table or does it have to be a spatial data set? Yes it can be standalone or spatial
3) Does it matter if the relate is set up in the data base or in the map? I have tested both ways and both work

Re: Problems with Relates and the Enhanced Search Widget

AaronMielke — Fri, 28 Sep 2012 20:37:02 GMT

Robert,
It looks like the problem is the secured service. When I click on the "Show Relates" icon it puts a request to the REST Services directory but it is not authorized to view the data. Somehow the token has to be embedded in the request. Currently the request is https://maps.barr.com/ArcGIS/rest/services/Demos/Test_Relate/MapServer/1?f=json

Thanks,
Aaron

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Fri, 28 Sep 2012 22:27:36 GMT

Aaron,

So how is the token being provided to me in this situation? Is it part of the search layers url or did you already have to login using the identity manager?

Re: Problems with Relates and the Enhanced Search Widget

RichDeBell — Thu, 03 Jan 2013 18:53:37 GMT

Hi I need to piggy back on this issue. I have the same problem with a secured url. Has any resolution been found for this?

thanks

Rich

Re: Problems with Relates and the Enhanced Search Widget

NinaRihn — Fri, 11 Jan 2013 14:55:05 GMT

Aaron,

So how is the token being provided to me in this situation? Is it part of the search layers url or did you already have to login using the identity manager?

I am having this problem too.. currently, my token is being passed just once, under the Layer URL:
<url>https://xxxxx.us/SQL/rest/services/WIARNG_Facilities/Fac_Basemap_WMAS_Cache/MapServer/0/?token=qNzOqxLPck6visgtQ9wY-NLoaT35el4VYrb7KKcCpbe1vsVTZs3WcvzI79B5w_hE</url>

I am able to search the layer, but then when I click the icon in the Get Related dialog, nothing happens even though I know there are related records for that layer record.

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Fri, 11 Jan 2013 15:39:29 GMT

Nina,

Thanks for the info. Yours is a situation that I can get fixed in the next release of the widget. In the latest release of the eSearch Widget I introduced a token element for each layer. If you put your token in there then I can use that in the next release to pass along to the relate query.

Edit: One of the other issues I see in your url you have a / after the layer id and that will cause an issue in my code. Make sure you do not use the / after the layer id:

<url>https://xxxxx.us/SQL/rest/services/WIARNG_Facilities/Fac_Basemap_WMAS_Cache/MapServer/0/?token=qNzOqxLPck6visgtQ9wY-NLoaT35el4VYrb7KKcCpbe1vsVTZs3WcvzI79B5w_hE</url>

Re: Problems with Relates and the Enhanced Search Widget

RobertScheitlin__GISP — Mon, 14 Jan 2013 14:29:52 GMT

All,

Another update is released:

Version 3.1.3 - 1/11/2013
* Fixed some issues with relates and uniquevalsfromfield when using tokens.
* Fixed some issues if the layers url contains the token.