What's the best way to get a list of user_id's followed by each user_id in either the Analytics or Application database?
I know that a follow is activity_type 270 and based on that I can pull fields like
but I'm not sure how to get a list and count of user_id's following other user_id's.
Perhaps jivedw_user_rel could be another approach, but my exploration of it thusfar has not been fruitful.
You can get this out of the Jiveuserrel table in the Core DB. Just be careful a query like the one below will return a ton of rows if you have an active community.
select juser.username, userrel.relateduserid from jiveuserrel userrel left join jiveuser juser on juser.userid = userrel.relateduserid