You need to sign in to do that
Don't have an account?
Arun K
Related SOQL
I have callString as detail object for account object
I am trying to retrieve callstrins related account name in below SOQL.
But I couldnt get it.
please help me in writing the right SOQL
for( Call_String__c doc:trigger.new){
List<Account> AccountList = [Select PDE1__c,Total_Calls_Formula__c,called_by_other__c , OwnerId, Co_Owner__c, Name from Account where name =:doc.Account__r.name ];
}
When I hard code account name and give as
"Select PDE1__c,Total_Calls_Formula__c,called_by_other__c , OwnerId, Co_Owner__c, Name from Account where name ='armand' then It is taking the armand account's related callstring
But when i try to get general account name, it is not not taking the related account name
For(Account a : [select id , (select id from callString__r from Account where id in : Trigger.New )])
{
for(CallString__c cs : a.callString__r)
{
system.debug('====CallString Record ===='+cs);
}
}
Here I have used chidl relationship "CallString__r" between CallString and Accoutn object but you need to findout it on master Detail fied on CallString object.