Takes two parameters, ChildTableName, Mode

Description:

The Alias of Attached Children Records will be added to the Query, using the specified mode. If more than one Parent Table exists in the Query, Child Records will be matched to any and all of the Parent Tables. So if you have 2 Parent Tables in the Query, the number of children would be doubled.

It is important to note that the regular Children and Parents commands confirm that a records exists while joining the data and if an attachment exists for a non-existent record it does not load that attachment. In contrast, for ChildrenAlias and ParentsAlias, because the record data is not read, it is unaware if the records actually exists or not. Therefore, attachments to non-existent records will be loaded.

Mode must be one of: "All", "One", "Discard"

• "All": Every Child Record for Every pre-existing Record will be loaded. If more than one Child Records exists the pre-existing Record will be duplicated. If no Child records are found for a pre-existing Record, the Records will remain with blank fields values for the Child table.
  
  
• "One": Only One Child Record for Every pre-existing Record will be loaded. If more than one Child Records exist the pre-existing Record a single Child will be chosen at random. If no Child records are found
  for a pre-existing Record, the Records will remain with empty fields values for the Child table.
  
  
• "Discard": Every Child Record for Every pre-existing Record will be loaded. If more than one Child Records exists the pre-existing Record will be duplicated. If no Child records are found for a pre-existing Record, the Records will be removed from the Query. Note that this is the typical behavior for SQL.

Examples:

SetNew      "MemTab.Person.Alias", ($SessionUser)
Children    "ToDo.List"
Children    "ToDo.Item"
KeepIf      "ToDo.Item.Alias", =, `pItem

 *Note: "All" is used as default mode when no mode is provided