Sign Up ›
  • Stephanie Rhodes
  • NEWBIE
  • 10 Points
  • Member since 2016
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 3
    Replies
SOLVED
7 replies

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.
SOLVED
7 replies

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.