1 Reply Latest reply on Jan 25, 2016 9:13 AM by Caton Guilbault

    How to get a list of user_id's followed by each user_id in either the Analytics or Application database?

    datasci

      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

       

      "activity_ts"

      "day_id"

      "user_id"

      "activity_type"

      "direct_object_type"

      "direct_dw_object_id"

      "indirect_object_type"

      "indirect_dw_object_id"

      "dw_container_id"

      "metadata"

       

      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.