-
Is it possible a multi-level relationship query on Chatter/Comments?
Is it possible a multi-level relationship query on Chatter/Comments?
-
4 Replies
-
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')];
-
Yes,It is possible a multi-level relationship query on Chatter/Comments? Separate the feed from the object to avoid a nested query.
refer this link:http://salesforce.stackexchange.com/questions/4/how-to-do-a-multi-level-relationship-query-on-chatter-comments -
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')];
-
Hi,
Try this -
List<FeedItem> testfeed = [SELECT Id (SELECT
Id, CommentBody, FeedItemId FROM FeedComments) FROM
FeedItem WHERE ParentId IN (SELECT Id FROM
sobject__c WHERE field__c = 'testvalue')];Hope this helps.
Log In to reply.
Popular Salesforce Blogs
Understanding Web Server Authentication Flow | Web App Integration
Integration Using Web Server Flow Allows apps with a secure client-server (private key or anything that can protect the private key) to access protected resources.…
Integrating One Salesforce Org to Another Salesforce Org Using REST API
Hello guys, Today, I will show you how you can integrate one Salesforce org to another Salesforce Org using REST API. For this, you will…
How to implement Salesforce Communities
Salesforce Communities is now considered as an important requirement that helps businesses to establish a connection with their customers, partners as well as employees. Specific…
