You need to sign in to do that
Don't have an account?
V'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.
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.
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
Following returns a list of people, groups, records, topics, and files that the specified user is following
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
Thanks in Advance.
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