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; } } }

Relates in Search Widget

PatriciaMoehring

Hi Robert: Thanks in advance for your help! Just so you know, Ken Carrier helped me get things started and now I'm trying to take over (that's a scary thought). So, we have most of the eSearchWidget searches working. The ones we seem to have the most problem with are those with relationship classes set up. I've looked through the pdf instructions and some things I'm sure will become more clear as I continue to work through all of my issues!:) The particular problem I am having is with the Sign Post feature and having the related Sign table information show up in the table. On various attempts, I've had the table show up with field names but no Sign data. However, after the search is complete I would get a message about not having the datagrid setup.

In the config.xml, I added the SearchWidgetFixedDG under the UI elements but I don't have a SearchWidgetFixedDG.xml as the config statement says I should; not really sure how I get that (like I said I'm new to this):


    <widget left="10" top="50"    config="widgets/Navigation/NavigationWidget.xml"             url="widgets/Navigation/NavigationWidget.swf"/>
    <widget right="0" left="0" bottom="0" config="widgets/eSearch/SearchWidgetFixedDG.xml" url="widgets/eSearch/SearchWidgetFixedDG.swf"/>
    <widget right="-2" bottom="-2" config="widgets/OverviewMap/OverviewMapWidget.xml"           url="widgets/OverviewMap/OverviewMapWidget.swf"/>
    <widget right="20" top="55"    config="widgets/MapSwitcher/MapSwitcherWidget.xml"           url="widgets/MapSwitcher/MapSwitcherWidget.swf"/>
<widget left="0"   top="0"     config="widgets/FeatureTooltip/FeatureTooltipWidget.xml"     url="widgets/FeatureTooltip/FeatureTooltipWidget.swf"/>
<widget left="0"   top="0"     config="widgets/HeaderController/HeaderControllerWidget.xml" url="widgets/HeaderController/HeaderControllerWidget.swf"/>

and under the widgetcontainer here is the Search widget info:

<widget label="Search" left="60" top="400" preload="open"
                icon="assets/images/i_search.png"
                config="widgets/eSearch/SearchWidget.xml"
                url="widgets/eSearch/SearchWidget.swf"/>

In the SearchWidget.xml:

<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Sign Post</name>
   <url>http://192.168.100.102/ArcGIS/rest/services/Signs/MapServer/0</url>
   <expressions>
    <expression alias="Sign Post" textsearchlabel="Search by Street Name: [ Example: ROSEMARIE or Rosemarie or rosemarie]">
     <values>
      <value>upper(OnStreetName) like upper('%[value]%')</value>
     </values>
    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select sign posts</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>OnStreetName</titlefield>
   <fields all="false">
    <field name="OnStreetName" alias="Street Name" />
    <field name="Subtype" alias="Post Type" />
    <field name="FACILITYID" alias="Post ID" />
    <field name="PCond" alias="Post Condition" />
    <field name="SonPost" alias="Signs on Post" />
   </fields>
   <relates>
    <relate id="0" label="Related Sign Information" enableexport="true" icon="widgets/eSearch/assets/images/i_relate.png">
     <fields all="true" />
    </relate>
   </relates>
   <zoomscale usegeometry="true" zoompercent="1.2"></zoomscale>
   <autoopendatagrid>true</autoopendatagrid>
</layer>

I did change:
<floatorfixed disablerelatestabinfixed="false">fixed</floatorfixed>

If you need any other information please let me know and thanks again! Patricia

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

PatriciaMoehring

Don't know if this would be a new thread but you know what happens when you give a mouse a cookie . . .

I currently have an eSearch set up for Parcels -- can be searched by address, parcelid, or ownername. Within the search popup is also a link to the County auditor's website with more information about the parcel (since I'm with a municipality). Then I have a Zoning feature, which consists of all the parcel shapes, the parcelid, zoning code, and additional zoning code info. A separate feature was necessary since one parcel can have more than one types of zoning. I do not have a relate set up but I suppose I could Parcel to Zoning -- 1:M -- based on ParcelID. And if everyone remembers I have a relate to a zoning table that gives the full description of the code and also a PopUp for zoning parcels set up.

Then he wants a glass of milk!

Economic Development really likes the ability to search parcels but once the search is complete, the parcel is selected, and the search popup appears; which means I cannot get the zoning popup to appear. So, is there a way to include the zoning code in the parcel search popup without creating the relationship class or do you think that is the only way to go?

I'm open to suggestions; I like banging my head against the wall!:)

Let me know if you think this should be a separate thread and I'll start one.

Thanks, Patricia

PaulTHEDUDELang

Below is working with multiple relates, relates are one too many.
eSearch works...

<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Relate Search</name>
   <url>http://gcgis/ArcGIS/rest/services/MyRelate/MapServer/0</url>
   <expressions>
    <expression alias="Parcel Number" textsearchlabel="">
     <values>
       <value prompt="Parcel Number Example: 150758">AKPAR = '[value]'</value>
     </values>
    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Roads</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>AKPAR</titlefield>
   <fields all="false">
    <field name="AKPAR" alias="PID #" gridfield="true"/>
    <field name="PIN" alias="PIN #" gridfield="true"/>
    <field name="CALCAC" alias="Calculated Acres" gridfield="true"/>
   </fields>
   <links>
    <link>
    </link>
   </links>
   <zoomscale usegeometry="true" zoompercent="1.6" />
   <autoopendatagrid>false</autoopendatagrid>
   <relates>

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

    <relate id="1" label="Sale Summary" enableexport="true" icon="assets/images/i_hydro.png">
     <fields all="true" />
    </relate>

    <relate id="2" label="Tax Work" enableexport="true" icon="assets/images/i_hydro.png">
     <fields all="true" />
    </relate>

    <relate id="3" label="AS400 Out" enableexport="true" icon="assets/images/i_hydro.png">
     <fields all="true" />
    </relate>

    <relate id="4" label="Mobile Video Images" enableexport="true" icon="assets/images/i_hydro.png">
     <fields all="false">
     <field name="Parcel" alias="Parcel" />
      <field name="ImagePath" alias="House Picture" hyperlinkgridfield="true"/>
     </fields>
    </relate>

   </relates>
   <queryattachments>false</queryattachments>
</layer>

PatriciaMoehring

Robert: I just thought I would let you know that the sign relate is now working. Don't ask me, I have no idea why! I was showing someone how to use the search queries and just tried the sign search anyway and it worked.

I could have just visited the twilight zone, I'm not sure! Since I've been working on the webmap I feel like I'm always in the twilight zone!

Just thought I would let you know!:)

PatriciaMoehring

Robert: Thanks, I did actually get 2 relates working. But on the one I had for parks relating to an attachment table I had to add a hyperlink field and populate it with the hyperlink address. I could not get the hyperlinkprefix to work.

Even though the Zoning works, does the url look strange to you. I would have thought the number after MapServer should have been 2 or 3 but not 1.

Anyway, if you think of anything please let me know. I'm stumped! And if anyone else out there has any ideas please share!

BTW, do you have a really cool widget for printing at 2.5?

Thanks, Patricia

RobertScheitlin__GISP

Patricia,

That does not help bring anything to mind. I am glad that you did get a relate working though.

PatriciaMoehring

Robert: This is really weird. I set the signs aside and started working on some other searches. I'm just sending this because this search is working and I don't really know why it should be working when the sign relate isn't? Anyway, I have a General Zoning Table that is related to the Zoning Parcels feature with a 1:M relationship and ZONE_ is in both tables and that is what the relate is built on. I've attached some pics of the REST for you to see. I thought this might spur some thought into why I still can't see the related signs. Pay particular attention to the url end number. So, here is what it looks like in Flex:

<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Zoning</name>
   <url>http://192.168.100.102/ArcGIS/rest/services/Zoning/MapServer/1</url>
   <expressions>
    <expression alias="Zoning Code" textsearchlabel="Search by Zoning Code: [ Example: CBD, GC, I-1, I-2, I-E, I-P, NC, NSC, PO, R-1A, R-1B, R-1C, R-1CC, R-1D, R-1U, R-2, R-3, R-R, RESORT, SC, PUD, RCD, MHP, GW]">
     <values>
      <value>upper(ZONE_) like upper('%[value]%')</value>
     </values>
    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select parcels</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>ZONE_</titlefield>
   <fields all="false">
    <field name="MACCT" alias="Parcel ID" gridfield="true"/>
    <field name="ZONE_" alias="Zoning Code" gridfield="true"/>
    <field name="ADD_Z" alias="Additional Zoning" gridfield="true"/>
   </fields>
   <relates>
    <relate id="1" label="Related Zoning Information" enableexport="true" icon="widgets/eSearch/assets/images/i_relate.png">
     <fields all="false">
      <field name="ZONE_" alias="Zoning Code"/>
      <field name="ZONE_DESC" alias="Zoning Description"/>
      <field name="GEN_ZONE" alias="General Zoning Code"/>
      <field name="GEN_DESC" alias="General Zoning Description"/>
     </fields>
    </relate>
   </relates>
   <zoomscale usegeometry="true" zoompercent="1.2"></zoomscale>
</layer>

ZoningREST.JPG

ZoningParcelBottonm.JPG

PatriciaMoehring

Robert: Are you sure you want to open that can of worms? I've attached the document that shows -- search for parks -- get the relationship window -- shows related park attachments -- click on hyperlink field -- get error message. The IT guy and Ken are going to look at it in the am. Unless, of course, you've seen this before and know exactly what the problem is!:)

The Sign Post to Sign is still an issue but like I said, if I perform a query from the REST Services, it works. See attachment. If you think of anything else that I may be missing, please let me know and I'll try to find it!

Thanks again for all your patience!

ParkRelate.docx

SignPostRelate.JPG

RobertScheitlin__GISP

Patricia,

You can't base very much on the fact that it works in ArcMap as that is SOAP based and does not involve ArcGIS Server which is REST based. The fact that you use something other than objectid field is actually best practice and exactly how every GIS person should do it.

However, the relate is working just can't open the images using the hyperlinkgridfield

are you talking about in ArcMap or in Flex?

PatriciaMoehring

Yes, but that's a whole other can of worms! However, the relate is working just can't open the images using the hyperlinkgridfield, think it has something to do with the ip address we are using and the whole virtual world? Have to wait till the it guy comes in tomorrow.

I know the relate is working since I can get it to work through the query and in ArcMap; just don't know why it's not working here. Could I use link or some other method.

I'm throwing this out there because I think it might be an issue -- I noticed in the Query related records the relate seemed to be based on Object ID. My relate is based on rSignPost Facility ID and rSign Post ID (1:M). So, when I did the query the post object id did find 3 matching records in the rSign table with the post id. But I did not use Object ID in the relationship class since they have a tendency to change when records get deleted.

I don't know, I'm just talking out loud! Aren't you glad you can't hear me!:)

RobertScheitlin__GISP

Patricia,

But the error window went away right? Do you have any other relates you could test on? I am running out of ideas here.

PatriciaMoehring

No, I'm still not getting the related data? Any other ideas?

RobertScheitlin__GISP

Patricia,

Flex is a case sensitive language, so:

<fields all="True"/>

is not correct it needs to be:

<fields all="true"/>

PatriciaMoehring

Ok, here you go!

<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Sign Post</name>
   <url>http://192.168.100.102/ArcGIS/rest/services/Signs/MapServer/0</url>
   <expressions>
    <expression alias="Sign Post" textsearchlabel="Search by Street Name: [ Example: ROSEMARIE or Rosemarie or rosemarie]">
     <values>
      <value>upper(OnStreetName) like upper('%[value]%')</value>
     </values>
    </expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select sign posts</graphicalsearchlabel>
   <spatialsearchlayer>true</spatialsearchlayer>
   <titlefield>OnStreetName</titlefield>
    <fields all="false">
     <field name="OnStreetName" alias="Street Name" gridfield="true" />
     <field name="Subtype" alias="Post Type" gridfield="true" />
     <field name="FACILITYID" alias="Post ID" gridfield="true" />
     <field name="PCond" alias="Post Condition" gridfield="true" />
     <field name="SonPost" alias="Signs on Post" gridfield="true" />
    </fields>
   <relates>
    <relate id="0" label="Related Sign Information" enableexport="true" icon="widgets/eSearch/assets/images/i_relate.png">
     <fields all="True"/>
    </relate>
   </relates>
   <zoomscale usegeometry="true" zoompercent="1.2"></zoomscale>
   <autoopendatagrid>true</autoopendatagrid>
</layer>

RobertScheitlin__GISP

Patricia,

OK, one more time send me you SearchWidget.xml so I can see how you applied the change. Can you do and actual copy and paste instead of a screen grab?

PatriciaMoehring

ok, so now here's the message.

SignQueryResult3.JPG

RobertScheitlin__GISP

Patricia,

So it does not display a popup message that say no relates forund, but it does flip to an empty relates datagrid tab? Try changing your RELATE fields back to this:

<fields all="true" />

PatriciaMoehring

And the relate table comes up empty!

RobertScheitlin__GISP

Patricia,

Great so now all you need to do is click the relate button in the widget results or in the datagrid then.

PatriciaMoehring

Robert: Ok, so now I'm getting sign post information in the search portion of the table but still nothing in the relate. See attached.

SignRelate2.docx

RobertScheitlin__GISP

Patricia,

OK, based on what you provided in your SearcWidget.xml you are still missing my instructions. You need to add the gridfield attribute to the fields of the Sign Post layer NOT the relate. I does not matter a bit if you have the gridfield attribute in the relates field element because those are always going to appear in a datagrid.

PatriciaMoehring

Robert: Thank you for your patience! Ok, the error message is gone. But I'm still not getting data in the table. Attached is snapshots of what I currently have in config.xml, searchwidget.xml and what I'm getting.

SignRelate.docx

RobertScheitlin__GISP

Patricia,

Lets work on one thing at a time.

If you add the attribute gridfield to the fields on your sign post layer then that will get rid of the "no datagrid configured for this layer" message.

            <fields all="false">
                <field name="OnStreetName" alias="Street Name" gridfield="true"/>
                <field name="Subtype" alias="Post Type"  gridfield="true"/>
                <field name="FACILITYID" alias="Post ID"  gridfield="true"/>
                <field name="PCond" alias="Post Condition"  gridfield="true"/>
                <field name="SonPost" alias="Signs on Post"  gridfield="true"/>
            </fields>

Once you make these changes then you need to be sure your browser is picking up this new xml file by clearing your browsers cache.

PatriciaMoehring

Robert: I tried that on data from the Sign table. Tried variations but nothing seems to work. What about that URL in the Enhanced Search Widget URL Search Configuration.pdf; where does the URL go. It seems like I'm missing something. I can get everything to work except for the related data to populate.

I'm still getting the message in the Search window that there is no datagrid configured for this layer.

So, I really don't know what to do now! Help, I'm stuck and the more I wiggle the deeper it gets!:) Let me know if you think of anything else or need anything from me. I'm going to try and squeeze some info out of Ken to see if he has any ideas on this but I think we are both kind of baffled -- him more than me; I'm just lost!

Thanks, Patricia

RobertScheitlin__GISP

Patricia,

It took me a while to see what your configuration issue was... You are using the fixed datagrid and you are not specifying any gridfields.

<fields all="false">
    <field name="OnStreetName" alias="Street Name" gridfield="true"/>
    <field name="Subtype" alias="Post Type"  gridfield="true"/>
    <field name="FACILITYID" alias="Post ID"  gridfield="true"/>
    <field name="PCond" alias="Post Condition"  gridfield="true"/>
    <field name="SonPost" alias="Signs on Post"  gridfield="true"/>
   </fields>

PatriciaMoehring

Robert: Ok, I didn't have the swf file either. So, some things are working and I didn't do anything else except add the swf in project properties/modules for the SearchWidgetFixedDG.

Attached is the result after running.[ATTACH=CONFIG]16636[/ATTACH]

So, now what do you think?

SignQueryResult.jpg

RobertScheitlin__GISP

Patricia,

Hmm, that explains why you did not have the file in your download. So if you are using Flex Viewer 2.5 than you do not need the SearchWidgetFixedDG.xml as it is just for Version 3.0.x.

So remove the config part from this line:

<widget right="0" left="0" bottom="0"  config="widgets/eSearch/SearchWidgetFixedDG.xml"   url="widgets/eSearch/SearchWidgetFixedDG.swf"/>

Or just comment it the whole line and use the floating datagrid instead. By changing this line back:

<floatorfixed  disablerelatestabinfixed="false">float</floatorfixed><!--  possible values are fixed and float -->

PatriciaMoehring

Robert: I think I may have just done a no no. So, the file that was downloaded for eSearch 2.5 did not have the SearcjWidgetFixedDG.xml. I downloaded the eSearch 3.0 and dragged the xml over to my projects.

Did I do good?

PatriciaMoehring

Patricia,

OK so let me get a few quick questions answered from you then.
Do you see the fixed datagrid in your app?
When you go to http://192.168.100.102/ArcGIS/rest/services/Signs/MapServer/0 in your web browser do you see Relationships list almost completely at the bottom of the page and do you see the query related records link?
Are you saying that the SearchWidgetFixedDG.xml was not in your download?...

1. I really hate to sound like a newbie (which I really am) but I'm not sure I know what you mean when you ask if I see the fixed datagrid in my app?
2. I did do a query and yes I get the related tables here.[ATTACH=CONFIG]16634[/ATTACH]
3. Ken told me how to get the xml over which I've done.

But now I'm getting WidgetError #2035

SignPostRelate.JPG

RobertScheitlin__GISP

Patricia,

OK so let me get a few quick questions answered from you then.

Do you see the fixed datagrid in your app?
When you go to http://192.168.100.102/ArcGIS/rest/services/Signs/MapServer/0 in your web browser do you see Relationships list almost completely at the bottom of the page and do you see the query related records link?
Are you saying that the SearchWidgetFixedDG.xml was not in your download?...

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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