I am trying to get a simple list of who in chatter commented on which authors post and I am struggling to get a correct SOQL. I want something like this
Bob -> Dave Dave -> Martha Bruce -> Martha
meaning that Bruce commented a post by Martha.
I expected this SOQL to do the job but miserably failed ;)
select CreatedBy.Name, FeedItem.CreatedBy.Name from FeedComment
I know that it works the other way around using
SELECT CreatedBy.Name, LikeCount, (SELECT CreatedBy.Name FROM FeedComments) FROM FeedItem ORDER BY LikeCount DESC
but I am having a hard time translating that into a flat csv-like format.