[SalesForce] Parent to Child SOQL

I have a Asset Table with Field Name like id and name.
I have a child relationship of the following Test_Result__c.System__c with field like resultTest1

Select Name, id , (Select something from the child) from Asset

How do you form a proper query to get for each Asset Name, id, the child resultTest1 ?

Best Answer

You need to give child relationship name in the subquery. Child relationship name can be found from the lookup in the child to Asset object. So your query will be like

Select Name, id , (Select Id,Name from ChildRelationshipName) from Asset

Related Solutions

[SalesForce] query flat list of records including parent and child fields

There are 2 ways in which you can wirte SOQL queries.

1) We can get child object fields/ records by using inner query like this :

 [Select, Id, Name, Client_Name__c, Proposal_Type__c, (Select Id from Questions__r) from proposal__c];

2) OR

 [Select Question__c, Proposal__r.Name, Proposal__r.Client_Name__c, Proposal__r.proposal_type__c from Question__c];

// we dont use plural form of parent object while quering on the child object.

This will solve your problem. If you still have any issues regarding SOQL queries, follow this link https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_query_using.htm#sforce_api_calls_soql_relationships_query_using

[SalesForce] Inner SOQL child to parent query

For parent field references the extra "select" keyword is not used:

List<detail__c> detailObj = [select id, master__r.Id from detail__c];

See the examples in the Using Relationship Queries documentation.

It is also not necessary to wrap the query results in a list; the query results are already a list of the correct type.

Best Answer

Related Solutions

[SalesForce] query flat list of records including parent and child fields

[SalesForce] Inner SOQL child to parent query

Related Topic