You need to sign in to do that
Don't have an account?
Stephanie Rhodes
Resort count Case with attachments
Hi.I am trying to create a report that returns a Count of Cases with Attchments. Record Type can't do this. I'm just learning SOQLso I ran a SOQL query but I get a result with a list of all Cases and Attachments. Here's my query:
SELECT Case.CaseNumber, (SELECT Attachment.ParentID FROM Case.Attachments) FROM Case
I know I am missing Count() but I don't know how to put it in. I just need a simple Count of Cases WITH Attachments. Thanks for helping.
SELECT Case.CaseNumber, (SELECT Attachment.ParentID FROM Case.Attachments) FROM Case
I know I am missing Count() but I don't know how to put it in. I just need a simple Count of Cases WITH Attachments. Thanks for helping.
You cannt able to run Group by in inner SOQL
All Answers
You cannt able to run Group by in inner SOQL