Feature Details and DataLinks on Layers

Permanently deleted user

27 Juli 2011 23:12

Version 2.5.0 GE, WebADF.

I have tried without success to have a Feature Layer (in our case, an assessment Parcel map) connect via Datalink to an SQL database which I have successfully setup and to display all fields in the Feature Details table.

The issue I am having is that even though the results from the join are a one-to-one relationship, the data is still being displayed as a separate data table to the right as opposed to combining the fields into the Feature Details table.

I have tried to map out fields of the layer along with the results of the datalink query also without success.  The administrator guide dictacted to use the format of datalinkname::datalinkfield and the formatting shows correct in right table but still does not combine all results in the Feature Details.

Here is a snippet of my XML file:

<LayerResourceManager ID="LayerResourceManager">

 

      <LayerResourceItems ID="LayerResourceItems">

 

        <Layer ID="_6c2c0758_3037_46e9_b24b_a3e7b7fe1a81" ItemIndex="0" Name="Parcel_Data.DBO.Parcels" Alias="Parcels" MapResource="Cecil" PrimaryKey="ARN">

 

          <DataLinks ID="EAI_DataLinks">

 

            <DataLinkSql ID="EAI_DataLinkSql" Name="EAI" DataLinkConnectionName="EAISQL">

 

              <Select ID="EAI_First_Name_Select" Distinct="False">

 

                <SqlSelectField ID="First_Name_SqlSelectField" Name="Parcel_General.First_Name" Alias="Primary_Owner_Name" />

 

              </Select>

 

              <From ID="EAI_From" Table="Parcel_General">

 

                <Join ID="ARN_Prop_Num_Join" Table="Parcel_Data.DBO.Parcels" Type="Inner" Field="Parcel_Data.DBO.Parcels.ARN" JoinToField="Parcel_General.Property_Num" />

 

              </From>

 

              <Where ID="EAI_Where">

 

                <ParameterGroup ID="ARN_ParameterGroup">

 

                  <FeatureFieldParameter ID="ARN_FeatureFieldParameter" Name="ARN" SqlField="Parcel_General.Property_Num" FeatureField="ARN" />

 

                  <ValueParameter ID="PrimeSub_ValueParameter" Name="PrimeSub" SqlField="Parcel_General.Prime_Sub" Value="0000" />

 

                </ParameterGroup>

 

              </Where>

 

            </DataLinkSql>

 

          </DataLinks>

 

          <Fields ID="Parcels_Fields">

 

            <Field ID="ARN_Field" ItemIndex="2" Name="ARN" Alias="Assessment Roll Number" />

 

            <Field ID="OBJECTID_Field" ItemIndex="1" Name="OBJECTID" />

 

            <Field ID="Length_Field" Name="Shape_length" Alias="Shape Length (m)" />

 

            <Field ID="Area_Field" Name="Shape.area" Alias="Shape Area (sq. meters)" />

 

            <Field ID="Owner_Field" ItemIndex="3" Name="EAI::Primary_Owner_Name" Alias="Owner" />

 

          </Fields>

 

        </Layer>

 

      </LayerResourceItems>

 

    </LayerResourceManager>

/customer/servlet/servlet.FileDownload?file=00P6000000e87z5EAA

Am I trying to do something that is not possible?  I would try 3.4 but we have not implemented ArcServer 10... yet.  Any insight or suggestions would be greatly appreciated.

Thank you in advance.

Cecil

 

0

• 

  Tom Kasmer

  27 Juli 2011 23:36

  Hi Cecil,

  I'm afraid that's not possible with the ADF viewer.  The datalinked data will always display on the right side in its own section.  

  With the Silverlight viewer however, 1:1 datalinks will show up in the same table as the feature details.

  0
• 

  Permanently deleted user

  27 Juli 2011 23:51

  Somehow I knew that was going to be the answer.  Thank you anyway.  Maybe a future feature in ADF?? :)

  0

Du måste logga in om du vill lämna en kommentar.