topic Re: Accessing Related Records with the Enhanced Search Widget in ArcGIS Viewer for Flex Questions

Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 13:00:53 GMT

I am creating a FlexViewer application using the Enhanced Search Widget and I cannot get the related records to appear in the application or the REST service. How would I get access to these records?

Re: Accessing Related Records with the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 06 Sep 2012 13:04:45 GMT

Michael,

Do you have the relates tag setup in your eSearchWidget.xml as documented?

Example (from the eSearchWidget.xml that comes with the download).

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

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 13:25:29 GMT

I was getting mixed up with the indices that should be used. The REST service gave the relate an index of 2 so I put that in for the relate ID and no related records were returned. When I changed the relate ID to 0, I was able to get related records.

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 16:57:10 GMT

Can the expression for the query be linked to the related records? It seems like all the samples are linked to the primary feature class or standalone table for each mapservice.

If this can be done, what would the proper syntax be?

Re: Accessing Related Records with the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 06 Sep 2012 17:02:27 GMT

Michael,

Relate are delivered as a "one to one" or "one to many" relationship with the search record that you click on, so I am lost as to what your question is...

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 17:18:43 GMT

Here is a query that I would like to perform against a mapservice representing parcels:

<expression alias="Parcels - Owner" textsearchlabel="Search Parcels by Owner...">
      <values>
          <value prompt="Example: Smith John" isvaluerequired="true">upper(OWN1) LIKE upper('%[value]%')</value>
      </values>
                </expression>

The OWN1 field is not part of the feature class, but is found in the related table. I want to be able to perform the query for the OWN1 field with this syntax but I get the following error message:

[RPC Fault faultString="Unable to complete operation." faultCode="400" faultDetail="Unable to complete Query operation."]

Re: Accessing Related Records with the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 06 Sep 2012 17:38:06 GMT

Michael,

Relates are very different than joins and because a relate is not actually added to the data there is now way to query for a relate field and an actual data field.

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 17:43:23 GMT

So would need to somehow get the field that is in the related record added to the primary feature class. There would be duplication of data, but that would be the only way to accomplish this task.

Re: Accessing Related Records with the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 06 Sep 2012 17:47:45 GMT

Michael,

Am I some how out of touch and you can now query in ArcMap for a layer and include a related layers field in the same query...

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 17:59:32 GMT

You are definitely not out of touch, as I never had the business need to perform this operation in ArcMap, just in a FlexViewer web application. Now that I know it can not be done I will find an alternate method. Thanks for the information, though

Re: Accessing Related Records with the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 06 Sep 2012 18:03:44 GMT

Michael,

Does your data actually require a relate (it has a one to many relationship) or can you just use a join (and then the field would be part of the layer)?

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 18:15:35 GMT

I need the relate as I have condos and trailer parks that have 1-many relationships.

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 18:25:56 GMT

Can you manipulate strings in the values area of the expression in the xml file?

I want to convert something like 1-Manhattan in the userlist and change the value to just capture the number 1 before the -Manhattan.

Re: Accessing Related Records with the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 06 Sep 2012 18:39:48 GMT

Michael,

No that is not possible currently. I have been considering the ability for a userlist to have a label and an different value, but I am not sure when or if I will get to this.

Re: Accessing Related Records with the Enhanced Search Widget

MichaelVolz — Thu, 06 Sep 2012 18:59:33 GMT

I could see that ability useful to many people who use coded domains as its the coded domain value that gets passed. Novice end-users would have no idea what the coded domain values are, but they would be familiar with the text value that is associated with the coded domain value.

I just joined my feature class to another feature class that has this value and populated a new field with the text value instead of using the field with the coded domain value. Since the data changes on a weekly basis, I will need to create a python script to update this process so new records get this field correctly populated.

Re: Accessing Related Records with the Enhanced Search Widget

RobertScheitlin__GISP — Thu, 06 Sep 2012 19:12:52 GMT

Michael,

Coded Domains are able to be uses as the values list as well as a userlist. You can find info on this capability on page 2 and 3 of the xml configuration pdf.