ParentToChildren Process

This ParentToChildren process shows how to do a parent-to-children relationship query and how to map the data to other activities.

The process is designed with the following activities:

The following table lists and explains the fields in the activities in the process.

Activity Description
Salesforce Query All Salesforce Query All activity.

Processes the parent-to-child relationship query.

The following statement is entered in the queryString field.

Select Id, Name,BillingStreet, (select Id, FirstName,LastName from Contacts) from Account a where a.Name='TIB_Sample_TIB' and a.BillingStreet='TIB_Sample_TIB’

Mapper Receives the returned data from the Salesforce Query All activity, and then maps the data values.

For detailed information, see Mapping Data in the ParentToChildren Process.