Force.com SOQL and SOSL Reference

Salesforce Object Query Language (SOQL)
SOQL Typographical Conventions
Quoted String Escape Sequences
Reserved Characters
SOQL SELECT Syntax
Relationship Queries
Understanding Relationship Names
Using Relationship Queries
Understanding Relationship Names, Custom Objects, and Custom Fields
Understanding Query Results
Lookup Relationships and Outer Joins
Identifying Parent and Child Relationships
Understanding Polymorphic Keys and Relationships
Understanding Relationship Query Limitations
Using Relationship Queries with History Objects
Using Relationship Queries with Data Category Selection Objects
Using Relationship Queries with the Partner WSDL
Change the Batch Size in Queries
SOQL Limits on Objects
Syndication Feed SOQL and Mapping Syntax
Location-Based SOQL Queries
Salesforce Object Search Language (SOSL)
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Using Relationship Queries with the Partner WSDL

The partner WSDL doesn’t contain the detailed type information that’s available in the enterprise WSDL which you need for a relationship SOQL query. You must first execute a describeSObjects() call, and from the results, gather the information you need to create your relationship query:
  • The relationshipName value for one-to-many relationships, for example, in an Account object, the relationship name for the asset child is Assets.
  • The reference fields available for the relevant object, for example, whoId, whatId, or ownerId on a Lead, Case, or custom object.

For an example of using the partner WSDL with relationship queries, see the examples on developer.salesforce.com (requires login).