[SalesForce] Query FeedComments for specific parent Type

For FeedItems this works in SOQL:

[SELECT Id FROM FeedItem WHERE Parent.Type = :mySObjectType]

But for FeedComment it is not a valid query:

Didn't understand relationship 'Parent' in field path

So I also tried to filter by key prefix:

String prefix = mySObjectType.getDescribe().getKeyPrefix() + '%';
[SELECT Id FROM FeedComment WHERE ParentId LIKE :prefix]

leads to:

invalid operator on id field

Is there any other workaround, or even a clean way to select Comments posted on a parent of a certain type?

EDIT:
Also tried

[SELECT Id FROM FeedComment WHERE FeedItem.Parent.Type = :mySObjectType]

Didn't understand relationship 'FeedItem' in field path

Best Answer

Sometimes fields declared as Reference do not really work as references. In such cases you need to use some ugly workarounds like this one:

SELECT Id, FeedItemId, ParentId, RelatedRecordId FROM FeedComment WHERE FeedItemId IN ( Select id from FeedItem WHERE Parent.Type = :mySObjectType )

Related Solutions

[SalesForce] FeedComment Parent relationship

Of course, I found that to get the Parent info in a trigger context I had to use an SOQL query.

But then, I found that even

FeedItem.Parent.get('Name');

doesn't work, since it is a polymorphic field. See here for a description of the problem, and here for a potential solution in the future.

So, I use the method FeedComment.ParentId.getSobjecttype() to get the object to describe. A complication is that the field to dynamically get may or may not be present in the org, and so I have to query non-statically, and catch any QueryException caused by the field not being present. Not ideal, but it seems to work.

[SalesForce] Migrating FeedComments and FeedItems

What do you mean by the FeedComment object is not accessible. You should be able to access it.

In an execute anonymous window try this

 list<FeedComment> fComments = [Select Id, FeedItemId, CommentType, CommentBody From FeedComment limit 25];
 system.debug(fComments);

What results do you get.

You should be able to extract the feedComment objects and reparent them in the same way that you have described above. Where exactly are you hitting an error?

Best Answer

Related Solutions

[SalesForce] FeedComment Parent relationship

[SalesForce] Migrating FeedComments and FeedItems

Related Topic