+ Start a Discussion

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

Wouldn't you want an IsPublished=true clause, and not the IsPublished=false you currently have ?