Parent-Child relationship query

childrelationshipqueryrelationshipssoql

Given Account – MaintenancePlan relationship, I have this SOQL:

SELECT Id, (SELECT id from MaintenancePlans WHERE Id = 'xxxxxxxxpUGAS') FROM Account

Problem is that I just need to get the MaintenacePlans which Id is specified in query, but I get all Accounts of my ORG. So, I need to make a query that just get MaintenancePlan with the ID 'xxxxxxxxpUGAS'.

Best Answer

You need to add a where clause in SOQL for Account and use join to filter account record, example:

 SELECT 
    Id, 
    (SELECT id from MaintenancePlans WHERE Id = 'xxxxxxxxpUGAS') 
    FROM Account WHERE
    Id IN (SELECT Account__c from MaintenancePlan WHERE Id = 'xxxxxxxxpUGAS')

// Here I assume, Account__c  is field API name and MaintenancePlan  is SObject API Name

Related Solutions

[SalesForce] SOQL Relationship Query : Compare Child and Parent field value in WHERE clause

I don't think so. The field expression in the where clause can include only 1 field name and not 2. It must be compared to a native value.

http://www.salesforce.com/us/developer/docs/soql_sosl/Content/sforce_api_calls_soql_select_fieldexpression.htm#fieldexpression

[SalesForce] SOQL Child –>Parent —->Child

Not entirely clear about your question. This answer assumes you have two child objects of one parent object.

From A Deeper look at SOQL and Relationship Queries on Force.com you need a Left Outer Join and a Left Inner Join, shown below:

id child1Id = ...;
Parent__c p = [
        select Name, (select ... from Child2s__r where ...)
        from Parent__c
        where Id in (select Parent__c from Child1__c where I = :child1Id)
        ];

String parentName = p.Name;
for (Child2__c child2 : p.Child2s__r) {
    ...
}

You can add where, order by and limit as needed to the Child2__c part of the query.

Best Answer

Related Solutions

[SalesForce] SOQL Relationship Query : Compare Child and Parent field value in WHERE clause

[SalesForce] SOQL Child –>Parent —->Child

Related Topic