+ Start a Discussion
krishnagkrishnag 

query help

hi,

 

I want to get some help in writing an SOQL query where the scenario is

 

i want the count of number of contacts where the account its related to have some field abc = true..

 

 

Best Answer chosen by Admin (Salesforce Developers) 
SuperfellSuperfell

Have you seen the SOQL-R section of the docs, there's lot of samples.

 

select count() from contact where account.some_field__c=true

All Answers

SuperfellSuperfell

Have you seen the SOQL-R section of the docs, there's lot of samples.

 

select count() from contact where account.some_field__c=true

This was selected as the best answer
krishnagkrishnag

thanks simon i know its a easy one but my mind is not working actually i got this after i posted this but anyways thanks for the reply.