Complex Copy Field to Descendants
Overview
For each record of the named type, the Complex Copy Field to Descendants macro copies the specified field (usually __ID or __ParentID, but it can be others) from each selected record to all of its descendants in the linkage hierarchy. This is useful if you want to find all records that belong underneath records of a given type so that the entire subtree can be manipulated at once. For example, suppose you propagate the __ID value from ancestors of type "100" down to a new field __Ancestor100ID in all descendants. Now you can query all records with a question like "are you a descendent of the type-100 record whose ID is 15"? This can support higher-level operations like tree splitting and re-balancing.
Complex Copy Field to Descendants macro configuration parameters
The Complex Copy Field to Descendants macro has a single set of configuration parameters.
Parameter | Description |
|---|---|
Type of parent record | Value of the __Type field of the parent records you want to copy.
|
Field to copy | Name of field to copy.
|
Field name on output | Name of copied field on output.
|
Configure the Complex Copy Field to Descendants macro
Select the Complex Copy Field to Descendants icon.
Go to the Configuration tab on the Properties pane.
Select Type of parent record box and enter the value of the __Type field of the parent records you want to copy (a parent record is a record that is higher in the tree as defined by the __ID and __ParentID fields).
Select which Field to copy, and specify the Field name on output.
Optionally, go to the Execution tab, and then set Web service options.