Is it possible a multi-level relationship query on Chatter/Comments?

Hi Himanshu,

Yes, we can do that, Here is a sample code, please try this and let me know if it is helpful

List<FeedItem> feedWithComments = [SELECT Id,Body,ParentId, (SELECT Id, CommentBody, FeedItemId FROM FeedComments) FROM FeedItem WHERE ParentId IN (SELECT Id FROM myObject WHERE Field = 'value')];

Hi,

You can use this query:-

List<FeedItem> feedWithComments = [SELECT Id,Body,ParentId, (SELECT Id, CommentBody, FeedItemId                                                                                  FROM FeedComments)

FROM FeedItem

WHERE ParentId IN (SELECT Id FROM myObject WHERE Field =                                                                                  'value')];