Adding a collection of elements from an IDO or a table to a BOD

There might be cases where you want to modify an existing BOD to add elements, based on columns in a table or an IDO. You can use the Replication Document Elements form to accomplish this.

  1. Open the Replication Documents form and execute Filter-In-Place.
  2. From the list of available BODs in the Grid View, select the BOD you want to modify.
  3. Click Elements.
    This launches the Replication Document Elements form in linked mode.
  4. On the Primary tab, create a new element record with these values:
    BOD Tag Name
    Leave this field blank or enter a tag name for the element group. This tag name will be an empty element, but it can be used to designate the tag start and ending point in the resulting BOD if Include Empty Element is selected.
    Value Type
    Set to Dynamic Subcollection.
    Dynamic IDO Subcollection Name
    From the drop-down list, select an IDO; or specify a table (by entering TABLE! plus the name of the table or the view; for example TABLE!UserEmails).
  5. On the Subcollection tab, set the Link Value to the property in the IDO or the column in the table from which the elements are to be taken.

    ...for example itemcust.item=item, which then links the table subcollection to the primary collection where item=item, or SLItemcusts.item=item for the IDO.

    You can add additional filter statements using the Filter field.

Note:  A collection name must be unique within the BOD. You cannot access TABLE!UserEmails filtered on one record in the collection and then access it again on another.

When you generate the BOD, it includes an element for each value in the table/view that matches the Link By and Filter statements.