How to retrieve who started following a user and when
By Carlos Bahiana on Friday, 20 May 2016
Posted in General
Likes 0
Views 439
Votes 0
Hi folks,

We are developing a solution to reward users who get most followed by other users in a community according to certain rules.

I found information on how to retrieve the total number of followers a user has and the total number of people the user is following, but not who started following a user and when.
Carlos Bahiana,

I am sorry for the delay of this reply. From #__social_subscriptions table where it stores the followers. To know who is following who, the user_id is whom that perform the follow (User1) button on the other user(User2). And the uid is the target user(User2) who has been followed. For the created column is when(date) the user1 following user2.
Please refer this screenshot: http://screencast.com/t/BqkN9XeB

Hope this helps
Muhammad Fadhli
·
Friday, 20 May 2016 12:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you so much, Fadhli!
Carlos Bahiana
·
Friday, 20 May 2016 18:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.
Arlex Wong
·
Saturday, 21 May 2016 00:45
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post