topic Re: Relates in Search Widget in ArcGIS Viewer for Flex Questions

Relates in Search Widget

PatriciaMoehring — Fri, 03 Aug 2012 13:36:33 GMT

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

Re: Relates in Search Widget

RobertScheitlin__GISP — Fri, 03 Aug 2012 13:59:07 GMT

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?...

Re: Relates in Search Widget

PatriciaMoehring — Fri, 03 Aug 2012 14:35:37 GMT

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

Re: Relates in Search Widget

PatriciaMoehring — Fri, 03 Aug 2012 14:43:29 GMT

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?

Re: Relates in Search Widget

RobertScheitlin__GISP — Fri, 03 Aug 2012 15:17:50 GMT

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

Re: Relates in Search Widget

PatriciaMoehring — Fri, 03 Aug 2012 15:26:21 GMT

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?

Re: Relates in Search Widget

RobertScheitlin__GISP — Sun, 12 Dec 2021 02:01:16 GMT

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>

Re: Relates in Search Widget

PatriciaMoehring — Fri, 03 Aug 2012 18:34:05 GMT

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

Re: Relates in Search Widget

RobertScheitlin__GISP — Sun, 12 Dec 2021 02:01:19 GMT

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.

Re: Relates in Search Widget

PatriciaMoehring — Mon, 06 Aug 2012 11:51:43 GMT

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.

Re: Relates in Search Widget

RobertScheitlin__GISP — Mon, 06 Aug 2012 12:00:09 GMT

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.

Re: Relates in Search Widget

PatriciaMoehring — Mon, 06 Aug 2012 13:19:36 GMT

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.

Re: Relates in Search Widget

RobertScheitlin__GISP — Mon, 06 Aug 2012 13:25:27 GMT

Patricia,

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

Re: Relates in Search Widget

PatriciaMoehring — Mon, 06 Aug 2012 13:36:34 GMT

And the relate table comes up empty!

Re: Relates in Search Widget

RobertScheitlin__GISP — Mon, 06 Aug 2012 13:50:45 GMT

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" />

Re: Relates in Search Widget

PatriciaMoehring — Mon, 06 Aug 2012 14:54:33 GMT

ok, so now here's the message.

Re: Relates in Search Widget

RobertScheitlin__GISP — Mon, 06 Aug 2012 15:17:30 GMT

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?

Re: Relates in Search Widget

PatriciaMoehring — Mon, 06 Aug 2012 15:41:45 GMT

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>

Re: Relates in Search Widget

RobertScheitlin__GISP — Mon, 06 Aug 2012 15:47:15 GMT

Patricia,

Flex is a case sensitive language, so:

<fields all="True"/>

is not correct it needs to be:

<fields all="true"/>

Re: Relates in Search Widget

PatriciaMoehring — Mon, 06 Aug 2012 15:59:58 GMT

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