+ Start a Discussion
V'NathV'Nath 

How to generate report on Topic and followers

How to generate topic and followers objects , i wanted to have each topic name and followers of that topic in a spread sheet?

Can we generate report and export to excel?

What is the difference between topic assignment and topic following , what objects refers these things in SFDC.
Gaurav KheterpalGaurav Kheterpal
You can create a report on topic assignments per record type. This was introduced in Winter 15 release. You can read more here - http://releasenotes.docs.salesforce.com/en-us/winter15/release-notes/rn_networks_analytics_reports.htm

Topic Assignment - when you assign a topic to a specific feed item or record
Topic Following -

You can read more details in the Chatter REST API Developer Guide (http://www.salesforce.com/us/developer/docs/chatterapi/)

If my answer helps resolve your query, please mark it as the 'Best Answer' & upvote it to benefit others and improve the overall quality of Discussion Forums.

Gaurav Kheterpal
Certified Force.com Developer| Salesforce Mobile Evangelist| Developer Forums Moderator| Dreamforce Speaker

 
Gaurav KheterpalGaurav Kheterpal
Forgot to add the following part earlier ->

Following returns a list of people, groups, records, topics, and files that the specified user is following
V'NathV'Nath
Thanks Gaurav,

 I am just looking for the Topic followers but if i generate report on Topic Assignment object it wil show the each topic for how many records it has added and user name.

ex : SFDC,Java,C Language  (Topic Names)

Now i have 10 users they are just following all the topics

Now i would like to see report like this;

SFDC - User1
Java - User1
C - user1
SFDC- user2
JAVA - user2
etc..

Check below screen shot , how users will be followin topics
User-added image
Thanks in Advance.
V'NathV'Nath
Gaurav,

Very straight question is here : Can we generate report on EntitySubscription Object? So that I can have Topic Subscriber name and Topic Name
Or
Only I can write class and page to export this details into spread sheet? 

Is there any best approach?

    list<Topic> lstT= [select Id,name from Topic  ] ;
    list<Id> topicID = new list<Id>();
    for(Topic t:lstT){
        topicID.add(t.Id);
    }
    list<EntitySubscription> EntitySubscriptionlist = [select id
                                                    , parentid
                                                    , subscriberid
                                                    , subscriber.email,Subscriber.name
                                                    , parent.name 
                                                from EntitySubscription
                                                Where parentid in : topicID];
    system.debug('E@@@@'+EntitySubscriptionlist.size());


Thanks,
VJ