I'm trying the following SOQL query on the FeedComment object on workbench and getting no records returned, though there are definitely records that should be returned.
SELECT Id, ParentId, RelatedRecordId FROM FeedComment WHERE CommentType = 'ContentComment' AND ParentId IN (SELECT Id from Stipend__c)
A similar query works properly on FeedItem.
On FeedComment, if I switch the query to filter for a specific ParentId, then it does yield a result.
SELECT Id, ParentId, RelatedRecordId FROM FeedComment WHERE CommentType = 'ContentComment' AND ParentId = 'a094000000HbbAfAAJ'
However, if I try to limit the IN clause to a single ID, I get an unknown error / unknown exception.
SELECT Id, ParentId, RelatedRecordId FROM FeedComment WHERE CommentType = 'ContentComment' AND ParentId IN (SELECT Id from Stipend__c Where ID = 'a094000000HbbAfAAJ')
FWIW, removing the CommentType filter has no impact.
My goal here is to find any chatter posts or comments on a specific object that have files attached. We are going to be doing some outsourcing, and these files could have sensitive data that needs to be hidden. I cant just turn off chatter on the object. I could turn chatter off just for the specific users, but would prefer to leave it on.
I have removed the filter on ParentID, retrieved all feedComment records, and am going to deal w/ this in excel, but for some related work on protecting attachments on approved records I need to understand if there is something about feedComment that is preventing me from running this query, or if it could be a bug that I should submit.
And finally, for the record, I do not know my joins well enough to name them - I'm taking that from this fine article.