You are here:

Custom Query Data Objects Tab

Use the Data Objects tab to select the objects that you want to include in this query.

To Select Data Objects For A Query

Select a Primary Data Object from the drop-down list. This is the main object from which you want to retrieve data.
If you want to join other objects in the query, select additional objects from the Child Data Object or the Parent Data Object drop-down lists.
Note: The field after the object name in the drop-down list is the field that is used to join the objects.
If you only want to select primary object records with at least one matching child or parent object included, select the Required (inner join) check box.
For example, if you select Account as the primary object and Contact as the child object with Required selected, the query only returns accounts that have at least one contact record. Accounts with no contacts are not included in the result set.
If Required is not checked and Account is the primary object and Contact is the child object, the query returns all Account records, whether or not the account has an associated Contact record.
To save the current query, click Save Query and select a location to save the query as an XML file.
To open a previously saved query, click Open Query and browse to the XML query you want to open.