Nested SOQL check if children exist on parent

Question

The Query should check if any children exist on the parent(opportunity) when i create a new child(project join). Where am I going wrong? Opportunity__c is master detail field on the child Project Join custom object. It is still pulling from all project joins and not the ones associated with the parent opp from which I am creating the new child record.

>  List<Project_Join__c> c = [SELECT id, opportunity__c FROM
> project_Join__c WHERE 
>         opportunity__c IN (SELECT id FROM Opportunity)];

score 0 · Answer 1 · answered Jun 20 '14 at 08:15

0

Lets say parentOppId is the parent opportunity Id. The query then should be

List<Project_Join__c> c = [SELECT id, opportunity__c FROM project_Join__c WHERE 
opportunity__c = :parentOppId ];

and now just check if c.isEmpty().

answered Jun 20 '14 at 08:15

Moti Korets

3,738
2
26
35

Nested SOQL check if children exist on parent

1 Answers1