You need to sign in to do that
Don't have an account?
need help in query
Hi All
I three custom objects those are Community_Member__c,question__c.answer__c
when i tried the following query
Community_Member__c c=[select name,(select header__c from question__r ) from Community_Member__c ];
its giving following error
Compile Error: line 1, column 23: Didn't understand relationship 'question__r' in FROM part of query call. If you are attempting to use a custom relationship, be sure to append the '__r' after the custom relationship name. Please reference your WSDL or the describe call for the appropriate names.
here paren is Community_Member__c
child is question__c
please help why i am getting error
thank you in advance
rajesh
Here is the answer :
http://boards.developerforce.com/t5/General-Development/need-help-in-query/td-p/278969
This is a duplicate post.
Thanks
Ankit Arora
Blog | Facebook | Blog Page
All Answers
Have you created a relationship between Community_Member__c and question__c? If you have created Community_Member__c will get a child relationship named as "Questions_r"
TRY this:
replace the question__r by Questions_r or questions_r.
If a reply to a post answers your question or resolves your problem, please mark it as the solution to the post so that others may benefit.
--
Chamil Madusanka
Here is the answer :
http://boards.developerforce.com/t5/General-Development/need-help-in-query/td-p/278969
This is a duplicate post.
Thanks
Ankit Arora
Blog | Facebook | Blog Page
thank you for yor answer
check this link for help.....
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_relationships_understanding.htm