function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
TatianaSmirnoTatianaSmirno 

Retrieving comments

I am very new to this sorry.  I've tried to use the chatter code recipie to retrieve comments on a feed item, but what code can I use to display it on my visual force page?

 

 

List<NewsFeed> myfeed = [SELECT Id, Type, 
                         CreatedById, CreatedBy.FirstName, CreatedBy.LastName,
                         ParentId, Parent.Name, 
                         Body, Title, LinkUrl, ContentData, ContentFileName,
                             (SELECT Id, FieldName, OldValue, NewValue 
                              FROM FeedTrackedChanges ORDER BY Id DESC), 
                             (SELECT Id, CommentBody, CreatedDate,
                              CreatedBy.FirstName, CreatedBy.LastName
                              FROM FeedComments ORDER BY CreatedDate LIMIT 10),
                             (SELECT CreatedBy.FirstName, CreatedBy.LastName
                              FROM FeedLikes)
                         FROM NewsFeed
                         ORDER BY CreatedDate DESC, Id DESC
                         LIMIT 20];
In my visualforce page I use:
<apex:dataTable value="{!userFeeds}" var="uf" >
I use {!uf.createdby.Firstname} to get the first name but I do not know how to get the comment body out.
Can you suggest what I could try?
Thankyou...sorry my english is not good.

 

 

sebcossebcos

Hi Tatiana,

the SOQL query retrieves a list of feeds and their related records, like comments, which are also lists.

You should be able to iterate again over the FeedComments list using the datatable as you have done for NewsFeeds. 

Something like this:

 

<apex:dataTable value="{!userFeeds}" var="uf">
      {!uf.createdBy.FirstName}
      <apex:dataTable value="{!uf.FeedComments}" var="uc">
          {!uc.CommentBody}
      </apex:dataTable>
  </apex:dataTable>

 

 

 
sridivyasridivya

i have tried to get comments,but i am not getting comments on Vfpage,can u plesae guide me to get comments on Vfpage,

 

i am pasting code which i have using,

 

Controller:-

 

 

public class commentsController {
List<NewsFeed> myfeed = new List<NewsFeed>();
    public List<NewsFeed> getUserfeeds()
    
      { 
      
            
         myfeed = [SELECT Id, Type, 
                         CreatedById, CreatedBy.FirstName, CreatedBy.LastName,
                         ParentId, Parent.Name, 
                         Body, Title, LinkUrl, ContentData, ContentFileName,
                             (SELECT Id, FieldName, OldValue, NewValue 
                              FROM FeedTrackedChanges ORDER BY Id DESC), 
                             (SELECT Id, CommentBody, CreatedDate,
                              CreatedBy.FirstName, CreatedBy.LastName
                              FROM FeedComments ORDER BY CreatedDate LIMIT 10),
                             (SELECT CreatedBy.FirstName, CreatedBy.LastName
                              FROM FeedLikes)
                         FROM NewsFeed
                         ORDER BY CreatedDate DESC, Id DESC
                         LIMIT 20];
      
              return myfeed; 
      
      
      }
    
}

 

 

 

Page:-

===========================================

 

 

<apex:page controller="commentsController">

<apex:dataTable value="{!userFeeds}" var="uf">

      {!uf.createdBy.FirstName}

      <apex:dataTable value="{!uf.FeedComments}" var="uc">

          {!uc.CommentBody}

      </apex:dataTable>

  </apex:dataTable>

 </apex:page>

 

 

 

please help me.

 

 

 

Thanks In Advance

 

    Sri