I am trying to get chatter feed in single SOQL query as below:
[Select id, Casenumber, (Select id, Title From FeedItems) From Case]
But its not working.
Is it even possible? Or else should I get it in separate SOQL query?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
The relationship name for feed items is
Feeds, not FeedItems. The below query should work:
[SELECT Id, CaseNumber, (SELECT Id, Title From Feeds) From Case]
You can query them like
Select id,title,body from casefeed