Esri / local-government-desktop-addins

A series of ArcGIS Desktop Add-ins used in the ArcGIS for Local Government editing maps.
Apache License 2.0
61 stars 57 forks source link

Enhance Copy Linked Records to perform statics operations #294

Closed MikeMillerGIS closed 5 years ago

MikeMillerGIS commented 5 years ago

Using the capital project layers. They want to get the max size of pipes included in a project. Need to use the Copy link records to traverse the relationship and get the max pipe size.

MikeMillerGIS commented 5 years ago

The method now support 7 parameters: Table below extends the current values. The new parameters are identical to feature stats: https://solutions.arcgis.com/shared/help/attribute-assistant/documentation/methods-all-methods/#feature-statistics

Parameter Value Description
Source Table Related table that a value will be copied from and placed in the triggering layer
Source Field Flag Source table field containing the values to copy and place in the triggering field
Primary Key Field name Field in the Triggering layer that is used to identify a feature in the source or related table
Foreign Key Field name Field in the source table with a matching ID to the triggering layers ID in the Primary Key field
Statistic Min Minimum value
Max Maximum value
Sum Sum of all values
Mean Mean
Concat Delimited string containing all the values with duplicates removed.
Delimiter (Optional) Any character except is valid; the default is ,. Characters used as delimiters; only used when the statistic is Concat.
SortOrder ASC Sort the statistics in ascending order; only used when the statistic is Concat.
DESC Sort the statistics in descending order; only used when the statistic is Concat.