+ Start a Discussion

Wishlist for v3.5 of the API

The one thing that would be great in the API would be to have the ability to access "Parent" tables on a SOQL query that could have a child object in the "Where" clause. 

For example it would be great if I could send in the query:

SELECT FirstName, LastName, Account.Name, Account.BillingCity FROM Contact Where LastName LIKE 'B%' AND Owner.RoleID = '1234xxxx1234'

The child query is not as important as the partent table access.