+ Start a Discussion

I have 2 custom objs Project (Parent) & BOM (Child). I want to list projects that have no BOMs Select Id, Name, BOM_Itemr.name from Projectc … where clause but “get didn’t understand relationship error” can you help?

February 11, 2021
·
Answer
·
Like
0
·
Follow
0

Andrew G
Try something like:
SELECT Name, (SELECT Id FROM BOM__r) FROM Project__c
note, you will need to check what the relationship name is for the lookup between Projects and BOMs. If the relationship name is BOMs, then adjust as
SELECT Name, (SELECT Id FROM BOMs__r) FROM Project__c
This document (https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql.htm)may provide more details/explanations

regards
Andrew

February 11, 2021
·
Like
0
·
Dislike
0

Lee Sadler
Many thanks - it was just child relationship name I had incorrect

February 11, 2021
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

I have 2 custom objs Project (Parent) & BOM (Child). I want to list projects that have no BOMs Select Id, Name, BOM_Itemr.name from Projectc … where clause but “get didn’t understand relationship error” can you help?

You need to sign in to do that.

Browse by Topic

Welcome to Support!

Show

sorted by

I have 2 custom objs Project (Parent) & BOM (Child). I want to list projects that have no BOMs Select Id, Name, BOM_Item__r.name from Project__c … where clause but “get didn’t understand relationship error” can you help?

You need to sign in to do that.

I have 2 custom objs Project (Parent) & BOM (Child). I want to list projects that have no BOMs Select Id, Name, BOM_Itemr.name from Projectc … where clause but “get didn’t understand relationship error” can you help?