IncludeChildTableAggregates
For the SOAP API, whether or not to include aggregate columns for child tables.
Data Type
bool
Default Value
true
Remarks
By default the connector exposes child tables as both XML aggregate columns on their parent table, as well as separate tables. For example, information on parties involved in reported safety incidents is available in two places:
- The Involved_Party_Data column on the ReportSafetyIncident table.
- The ReportSafetyIncident_Involved_Party_Data table.
If this option is disabled the aggregate column is not exposed and only the child table is available.
Note that this option does not affect aggregate columns on child tables. The connector does not expose second-level child tables, so these aggregates are the only way to access deeply nested data.