You need to sign in to do that
Don't have an account?
How to query "Public" casecomments SOQL
Salesforce gurus,
I am attempting to query all open cases and including case comments that have been "made public" that the users get to see via self service portal. As you can see i originally thought the "ispublished" was the bool flag, but apparantly I was wrong -- all comments are displayed. How do I include Public Case Comments to my query below?
SELECT CaseNumber, Subject, Status, CreatedDate, (SELECT CommentBody, IsPublished, CreatedDate from CaseComments where IsPublished = false ORDER By LastModifiedDate DESC LIMIT 1) FROM Case where Case.Account.Name like 'SomeAccountName%' and IsClosed = false ORDER BY Status ASC