Didn't understand relationship

Question

I'm getting an error - didnt understand relationship when running this query in dev console. I have set the child relationship the lookup field to IncEvents. The lookup field is on the MyRule object -

select Id, Name, (select Id from IncEvents_r) from Namespace_MyRule__c

I noticed that the editor is displaying a single underscore between the namespace and the object name but I did enter a double underscore.

Answer 1

Lets explain this with an example

I have a two custom objects named Position__c (Parent) and Job_Posting__c(Child).

Here is how I will approach the query

1. First I will go to the child object sreen

   

2. Next I will go to the parent lookup field and click on it to find child relationship name

   

3. Next step will be to write the query in the query editor of developer console properly

   Select id,name ,(Select Id,Name from Job_Postings__r) from Position__c
   

   

Note: Be sure to include a Namespace Prefix when one is listed on the sObject. For example, a Parent/Child object with a "ns" prefix would have a query like this:

select id, name, 
(select id, name from ns__Child_Relationship_Name__r) 
from ns__Parent_Object__c

An interesting thing is developer console now supports the sub-query .