You need to sign in to do that
Don't have an account?
Arav Sundar
How to query the count of child record
Hi ,
i am having an custom object of Location which has a lookup to account and i am trying to perform the soql query to get the locations which is greater than 1 from the account object , below is the SOQL query can someone see this and suggest me on the same
Select id,name,(SELECT id,Name From SVMXC__Site__r ) from Account
i am having an custom object of Location which has a lookup to account and i am trying to perform the soql query to get the locations which is greater than 1 from the account object , below is the SOQL query can someone see this and suggest me on the same
Select id,name,(SELECT id,Name From SVMXC__Site__r ) from Account
TRy below code.
Let us know if this will help you
this is the code my thing is i just want to query the count of the related list in SOQL Query itself
You can try below code.
PLease let us know if this will help you